Handling library references when distributing worksheets

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I've just written a complex VBA-enabled project that gets sent out to
60+ people via a background call to Lotus Notes. It invites them to
fill in information on the spreadsheet, then submit it back to me via
a spreadsheet button and another background call to Notes.

Naturally, however, we have encountered a few problems. While the
code seems to work fine in Excel 2003, it does not work in Excel 97 -
hardly surprising, but a pain in the neck. I'm confident I can
program around this to some extent, however.

The bigger problem is there seem to be missing libraries on a number
of machines. Or, not missing libraries, but ones that are not in the
expected location. I am referencing the following libraries:

Visual Basic for Application
Microsoft Excel 11.0 Object Library
OLE Automation
Microsoft Office 11.0 Object Library
Windows Script Hosting Model
Lotus Domino Objects
Lotus Notes Automation Classes

One one occasion, someone submitted his spreadsheet back to me and it
said *I* was missing a library! It turned out that it was, for some
reason, trying to reference D:\ for the Lotus Domino Objects
(domobj.tlb) instead of C:\, which is what I had set it to. What
could cause this?

More importantly, is there any way I can programatically search for a
missing library if it can't be directly referenced?

Any and all suggestions welcome,

Tristan

.

Relevant Pages

  • Re: Handling library references when distributing worksheets
    ... Another way is to use late binding, where you don't reference the libraries, ... The bigger problem is there seem to be missing libraries on a number ... trying to reference D:\ for the Lotus Domino Objects ...
    (microsoft.public.excel.programming)
  • Re: List box display of external text files
    ... the TestIt function. ... I must have some missing libraries. ... the CDC may stop working. ...
    (microsoft.public.access.externaldata)
  • Re: Beginners request
    ... whining about missing libraries there would not be any. ... So if some noob announces cl-speech it may suck at being Lispy, but if it works at all I for one will be on it like ugly on an ape offering contribs. ... The macrology is the fun part, not so much the "hello world" bit of just getting a Lisp program to get a C library merely, well, to speak "Hello, world.". ...
    (comp.lang.lisp)
  • [Full-Disclosure] Re: RC4 and Lotus Notes
    ... I'm coding with the libraries from Domino 6.0.1 domestic version, ... This is Lotus Notes we are talking ... the message regardless of how it was encrypted then hands it to a local ... Linux MDA ...
    (Full-Disclosure)
  • Re: Handling library references when distributing worksheets
    ... When the file makes a round trip, the library reference might update ... Jon Peltier, Microsoft Excel MVP ... The bigger problem is there seem to be missing libraries on a number ... trying to reference D:\ for the Lotus Domino Objects ...
    (microsoft.public.excel.programming)