I have been using a reference to the Excel 9.0 object library (Excel9.olb) file to programmatically export a mshflexgrid to a excel format report from my VB 6.0 program in windows 2000. I have seen that my installation folder has Excel9.olb file but is not copied to the directory where the executable is installed, which is ok or actually better.

However, recently, i got windows xp with office 2002 (office xp) and once I compile the program and try to run in a pc where we have windows 2000 with office 2000, my program crashes when I try to use a feature using excel object library. Also, I have noticed that instead of using something similar to Excel9.olb file (about 620 kb), the program is now referencing to the actuall application Excel.exe file which is about 8 MB. On the top of that, this Excel.exe is copied to the installation directory.

I have tried to do some search around in microsoft. Anybody experienced similar problem and what possible solution there might be?

Would appreciate any input.