Re: Handling library references when distributing worksheets

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

The better way is to install the LOWEST versions of each of the applications
that any of your users might have on a machine, and develop and test your
code on this, then distribute that.

Another way is to use late binding, where you don't reference the libraries,
they get looked up at run-time. Here is an article about a development
methodology (using Outlook, but the principle is the same)
http://xldynamic.com/source/xld.EarlyLate.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



<relative_virtue@xxxxxxxxxxx> wrote in message
news:1171540775.852689.44250@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: Library Database
    ... That's if you're doing it the way the Help file documents, ... You have to close the database to get rid of the reference. ... I've never had references to these libraries. ... There is a section entitled "Library Database ...
    (comp.databases.ms-access)
  • Re: Access 2003-Access 2002 Incompatibility
    ... Microsoft ActiveX Data Objects Recordset 2.7 Library ... The first one corresponds to msado15.dll (and adds the ADODB reference), ... There are two ADO type libraries. ...
    (microsoft.public.access.conversion)
  • RE: Built in function errors.
    ... Control reference, ... updating the software on the client computer and reselecting all ... reselect libraries simply makes the application not worth building using ...
    (microsoft.public.access.modulesdaovba)
  • Re: DB not working on other computer
    ... problem is fixed when I install Service Pack 1. ... referenced to regarding libraries and their relationship to projects. ... calculated controls if there are controls that contain expressions" ... > A "Missing" reference means that the files needed for a specific library are ...
    (microsoft.public.access.gettingstarted)
  • Built in function errors.
    ... TLBs on the client computer. ... reselect libraries simply makes the application not worth building using ... reference setup after resetting the references on the same computer. ... - Do not reference controls to use a value in automatic calculations on ...
    (microsoft.public.access.modulesdaovba)