Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBE ToolsReference question
Hi,
I do have a question abouth the Tools - Reference in the VB editor (Excel 2000). Is it possible to add programmaticaly references in the Workbook_open event in run time? If so, how to do so? Question comes from some problems i encounter in distributing my utility on 2 other PC's, located at around 70 miles from my home. Normally, in design time, you select the nessesarry library's to work with (example MSMAPI.OCX, FM20.DLL). but the other PC's does'nt have those librarys selected. So, the idea rise to write some code in the Workbook_open event to find the location of the nessesarry librarys (OCX, DLL, ...) and select them. This would be more convienient then hanging on the phone with someone who knows nothing abouth the VBE and selecting those library's. There's also a problem if those librarys doesn't appear in the list and have to be found manually. Any help welcome. Regards, Ludo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Same Office 2003 but different VBA ToolsReference (object ref.) | Excel Programming | |||
Same Office 2003 but different VBA ToolsReference (object ref | Excel Programming | |||
Microsoft.Office.Tools reference | Excel Programming | |||
VBA: Tools - Reference | Excel Programming | |||
Shareware Edwin's Power Tools decompiled and became Excel PowerPlus Tools | Excel Programming |