| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check If COM Reference Available on Machine
I have a VBA project which has a reference to the "Microsoft DTSPackage
Object Library" I have another workbook that opens the first one. Some machines, that will be running this don't have the "Microsoft DTSPackage Object Library" available since SQL wasn't installed, so I need a way for the first workbook to test whether or not the reference to that is in the list of available references before it allows the user to open the second workbook. I have seen code on how to check if a reference is broken, but the VBProject.Refenences collection only tests what references are being used in the current project, not what references are in the list as available. How do I do this? thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable sheet reference check | Excel Worksheet Functions | |||
| Check-box relative reference | Excel Discussion (Misc queries) | |||
| Check Box reference name | Excel Discussion (Misc queries) | |||
| Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
Threaded Mode
