Excel and VB6 Help Please!

[Ferlin]

I have an application that I have been using that exports an ASCII file to Excel 97. The application was running fine. A lot of my clients are still using MS Office 97 on older machines. I upgraded my machine to Windows XP, but installed MS OFFICE 97 on it. Now I am trying to make changes to my application, but all the methods it seems are hitting a failed error on my excel object now. Is there an issue or problem with using VB6 and Excel 97 on XP? I tried reinstalling Excel 97, but that made no difference.

Any help would be highly appreciated.

Thanks In Advance.

Ferlin.

 

[Sypher2]

There shouldn't be a problem running a VB6 app on Windows XP. Without knowing exactly what error message you are getting, here's a few things you can try...

-Look under Project|References for the Microsoft Excel 8.0 Object Library. Make sure it's checked. It's possible there could be 2 selections of this if you reinstalled Office (not likely, though).

-Try running the application through the IDE to get a more definitive error message and a line of code that is starting the goof.

 

[Ferlin]

Sypher2,

Thanks for the reply, the message I was getting was a method failed error, no matter what method I used. I talked to the very first client that I needed to make the changes to the application for, and they had XP and Excel 2000 installed on thier machine, so I upgraded MS Office to 2000 and it changed the library in VB to 9.0, the application ran fine then. I was running it under the IDE.

Although I don't know how that would effect the clients with older window's versions and Excel 97. So for now I'm keeping two copies of the application one with the 8.0 library and one with the 9.0 library. Just in case.

Again thanks for the reply.

Later.

Ferlin.