Automation Error.

[tatochka]

I have a VB6 application that calls Excel to read and write data. It worked absolutely fine on Windows 2000 machine. Now I got Windows XP and every time VB tries to call Excel I get the message "Error -2147417851; Description: Automation error. The server threw an exception." I tried everything I could: updated windows, reinstalled Microsoft Office (2003), updated office. Nothing helped.

Can someone help me on this? Thanks.

 

[Jump1ng]

Now I'm not a huge user of VB and neither a VB programmer.

But I have found that most problems with VB is the runtimes. I would try and download the latest runtime pack and see if that helps.

If you still have the problem you might need to find out what runtimes your VB6 application needs as sometimes you need to install and older version of the runtime to get it to work.

Can you get in touch with the person who wrote the program in teh first place? Maybe its written in a way that it will not work under Windows XP without modyfing the code.

Hope you get your problems sorted.



---
Make the best use of what is in your power, and take the rest as it happens.