Adding multiple Office References

[PamelaDV]

OK - I am getting an odd error in my application. I have done my
research and discovered that the error I am getting (Function is not
available in expressions in table-level validation expression) is
actually a references problem.

I run Office 2003 on my computer and in this last version that I
created of my Access application I created a reference to Excel for
some functionality that I created to export reports from Access to
Excel. I believe that my problem is that most of my users have Office
2002 on their machines - so the reference that I have for Excel 2003 is
going to be different and not in the same place.

So my question (I promise I'm getting to it) is ....

Is there any way that I can add the Excel 2002 reference to my
application without having Office 2002 installed on my machine?

Also, I distribute the application with a wise installer. Would I be
able to specify the location of the excel.exe reference in the
installer?

Any help is greatly appreciated.

Thanks!

 

[Rick Brandt]

OK - I am getting an odd error in my application. I have done my
research and discovered that the error I am getting (Function is not
available in expressions in table-level validation expression) is
actually a references problem.

I run Office 2003 on my computer and in this last version that I
created of my Access application I created a reference to Excel for
some functionality that I created to export reports from Access to
Excel. I believe that my problem is that most of my users have Office
2002 on their machines - so the reference that I have for Excel 2003
is going to be different and not in the same place.

So my question (I promise I'm getting to it) is ....

Is there any way that I can add the Excel 2002 reference to my
application without having Office 2002 installed on my machine?

Also, I distribute the application with a wise installer. Would I be
able to specify the location of the excel.exe reference in the
installer?

Any help is greatly appreciated.

Thanks!

Google these groups on the term "late binding". It is a way to utilize external
code libraries without adding a reference at all. Then your code works despite
the version the user has installed (as long as the calls you make to the library
ar not version sensitive).

It is actually an easy conversion to make if you already have functioning code
with early binding and it really is the ONLY way to build apps that will be used
on multiple machine configurations.

 

[PamelaDV]

Thank you Rick! I have taken your suggestion. I have changed my code
to utilize late binding and I am going to try it out tomorrow. I will
let you know how it goes. Thank you very much for your advice.

Pam

 

[PamelaDV]

Rick - this did work. Thank you very much!

Just as an FYI ... the following article was of the most help to me
....

http://www.granite.ab.ca/access/latebinding.htm