Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an add-in loaded all the time that checks any opened workbook name
for a specific string. The below code does this except when excel is opened with no workbook (i.e. from Programs Menu). This code resides in the App_WorkbookOpen event in the add-in. How can I suppress the error generated when no workbook is opened when excel opens and is loading my add-in with below code? The Application.ActiveWorkbook.Name object is null and that's causing the error. If InStr("History by Length", Application.ActiveWorkbook.Name) 0 Then MsgBox "it is our file" Call CreateMenu End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
Error Loading DLL | Excel Discussion (Misc queries) | |||
Error loading DLL | Excel Programming | |||
Error Loading DLL | Excel Programming | |||
Error Loading dll | Excel Programming |