Loading Libraries to other comp.

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

 

[Steve Schapel]

Dan,

Presumably the reason for the Excel library reference is because your
database is using it in some way, and this would imply the need for
Excel to be installed on the computer. Am I right? So do you mean that
the other computers do not have Excel installed, or that they have an
earlier version of Excel? The simplest way I can think of is to set the
reference on the other computers to the Excel library that they have
available.