How to add MS Excel 9.0 Object Library

[Dan]

I created an access database that its vba references to
the library Microsoft Excel 9.0 Object Library. The
problem I am having is that when other co-workers open
the database they get an error message:

"Your MyDatabase database or project contains a missing
or broken reference to the file 'Excel.9.OLB' version 1.3"

And therefore, they cannot run the database. Some co-
workers have Windows 98 or even 95. Is there some how I
can add this library into those computers that don't have
this library? Is so, what are the procedures I would
need to take?

Thank you.

 

[Rob Bovey]

Hi Dan,

The root of the problem is that these users are probably running an
earlier version of Excel than the one you're working with. There are two
ways to solve this. You either need to compile your application using a
reference to the earliest version of Excel that you need it to run with, or
you need to use late binding and remove the reference to the Excel object
library completely.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *