Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trapping the "Can't find project or library error"
Hi
I have many workbooks on a school system that make reference to a common Addin for the macros required. Sometimes when a workbook is loaded for the first time, it does not know where the reference Addin workbook is located. This generates the following error: Compile error: Can't find project or library - and also places the unsuspecting user in the VBE mode. How can I trap this event ? Thanks in advance Andrew Bourke |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trapping the "Can't find project or library error"
Hi Andrew,
A simple way would be to have a dummy function in the add-in, and make a call to it early in your code. You can determine there whether the add-in is loaded or not Dim myVal On Error GoTo no_addin myVal = Application.Run("myAddin.xla!myFunc") Exit Sub no_addin: MsgBox "Add-in not installed" -- HTH RP (remove nothere from the email address if mailing direct) "Ajtb" wrote in message ... Hi I have many workbooks on a school system that make reference to a common Addin for the macros required. Sometimes when a workbook is loaded for the first time, it does not know where the reference Addin workbook is located. This generates the following error: Compile error: Can't find project or library - and also places the unsuspecting user in the VBE mode. How can I trap this event ? Thanks in advance Andrew Bourke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
indirect.ext - "can't find project or library" error | Excel Worksheet Functions | |||
Trim: Excel 97 gives error "Can't find project or library" | Excel Programming | |||
adding reference "can't find project or library" | Excel Programming | |||
macro error "can't find project or library" | Excel Programming |