Another Excel with VB
Another Excel with VB
(OP)
Hi again,
I've written a VB application which handles with excel files. I've made an .exe from it and ran it and it works fine. However, when I'm tring to run the exe on a computer with WinXP, I'm encounter errors. When I re-compile the code in the XP computer (the same code, no changes!) the exe run just fine.
Anyone has a clue?
Shay
I've written a VB application which handles with excel files. I've made an .exe from it and ran it and it works fine. However, when I'm tring to run the exe on a computer with WinXP, I'm encounter errors. When I re-compile the code in the XP computer (the same code, no changes!) the exe run just fine.
Anyone has a clue?
Shay





RE: Another Excel with VB
To find out which files and dependencies exist, look under PROJECT-REFERENCES and PROJECT-COMPONENTS. You will see which components and library files are being used by your application. Usually, these files are backwards compatible So if you compile the program on the XP machine, it should work for previous OS systems as well.
If, however, your dependencies include different versions of the Excel library, you will need a different approach. Let me know ...
RE: Another Excel with VB
But I've managed to solve it like that -
I've define the excel components as object
(dim oExcel as Object
istead of
dim oExcel as Excel.Application
)
and used the CreateObject to create it.
Now it works...
Shay