Loading libraries to other comps

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

 

[Cheryl Fischer]

If the libraries on your co-workers' computers are simply in a different
folder from your computer, you can fix this by opening your Access database
on each user's computer, deleting the reference and then adding it again,
selecting the location in which it is found on the user's computer.

If your program attempts to Automate Excel by creating or opening a
spreadsheet, then your co-workers must also have Excel installed. If your
co-workers/users do not have Excel installed, then it would be a violation
of your End User License Agreement for you to copy this library to someone
else - and it probably would not work anyway.

 

[Albert D. Kallal]

The only real solution here is to use late binding.

Maybe the user has a newer version of Excel?

The real trick is thus to remove all those references to Excel, outlook,
Word.

In fact, you want to pair it down to the absolute min.

With late binding...I have successfully automated word code from a access97
program, but that access97 program has run with EVERY conceiving mix of
operating systems and every mix of office versions. Not one problem has
occurred. This is due to using late binding.

Here some info:

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