Problem w/ references

[Tony Botelho]

I have currently updated a database to export a report to
Excel. When I run it from my computer it works fine. The
problem is that although the other users on the network
have Excel, they have an older version. So when I point my
reference to --> Microsoft Excel 10.0 Object Library, it
looks for the reference in the Office10 folder.
Unfortunately the other users don't have this folder
(there Excel.exe is in a different folder), so there
reference shows up MISSING, and they get an error upon
opening the database.

How can I correct this? Any help would be greatly
apreciated.

(also if anyone knows where I can get additional
information about references - understanding the way
priorities work, etc - that would also help me out)

Thanks in advance
Tony

 

[david epsom dot com dot au]

reference shows up MISSING, and they get an error upon

1) Remove the reference

2) Change all code that uses the reference

For example, any object that is declared as a worksheet,
change the declaration to just be an object.
Any place that you have used the predeclared constants,
replace them with actual values. (You may use
the immediate window to find the actual value of a
constant: type the name of the constant, put a question
mark in front of it, and press [Enter]

(david)