Another Excel with VB

[shay11]

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

 

[TejuKey]

Most likely, you are using a library/dll/control that has been updated in XP. So when you recompile on the XP machine, it compiles with the newer version and runs correctly. If you need the code to run on different OS's, try using the most recent version of the file in question on all systems.

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

 

[shay11]

Thanks, that's probably the problem.
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