Excel and VB6 Help Please! 1

[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.

 

[CCLINT]

If that's all that you are doing, exporting a text file to Excel, then why not just use ADO?

There are some examples in this forum and on the MSDN site.

As to the actual cause, how are you using the Excel library? (Referencing it under PROJECT|REFERENCES, or, using the CreateObject method). [/b][/i][/u][sub]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!

 

[Ferlin]

CCLINT,

Thanks for your prompt reply. I am using the Excel library by referencing it under PROJECT|REFERENCES. The clients have programs that were written in another language running on a AIX (RISC 6000) system, a program on the AIX system takes data from the database there and creates a flat ascii file, it then uses Z-MODEM to transfer that file to the clients PC, then it executes the VB application that takes that ascii file and exports it into Excel then brings up Excel with that workbook in it.

All this has been working and is on the clients machine, the clients have recently added some new reports to that databases, when I tried to update the VB application that is when I had this problem.

Thanks for any help.

Ferlin.

 

[CCLINT]

Compare the versions of the Excel object library on the client's machines to yours. Is it the same version as you were using before?

[/b][/i][/u][sub]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!

 

[CCLINT]

Did you apply the '97 office service pack? [/b][/i][/u][sub]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!

 

[Ferlin]

CCLINT,

I was having the problem on my computer trying to make changes to the source. I upgraded my MS Office to MS Office 2000, since the immediate client that has the database changes just installed Windows XP on thier PC's also and are using Excel 2000. When I did that the program ran with out a hitch. Don't know if it is a compatibility problem with XP and Excel 97 using the 8.0 library in VB6 or what, but for now just in case the new version of my application doesn't work on the older machines, I'll keep two copies of it, till all my clients upgrade some day.

Again thanks for all your help.

Later.

Ferlin.