actually i've discovered my code in my previous post is failing even when i
open a workbook.

error is

Object variable or With block variable not set

what's wrong with that syntax?


"scott" wrote in message
...
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