Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Handling library references when distributing worksheets
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Object Library References | Excel Programming | |||
Distributing a workbook app with References | Excel Programming | |||
Library references | Excel Programming | |||
Object Library References | Excel Programming | |||
preserving type library references when distributing macros | Excel Programming |