Is Active Workbook ="ABC"
 

Excel 2002, WinXP
I have a user-created menu item that is applicable to only one file. That
menu item is created/deleted by code that is in that one file. However,
other files may be open at the same time and I need to make sure that this
one file, "ABC", is the active file before executing the menu item code.
I thought that ThisWorkbook was always the active file but it isn't.
ThisWorkbook is the file that holds the macro that is being executed.
How do I check for the active file, as in:
If (the active file).Name < "ABC" Then MsgBox "Wrong File"
Thanks for your help. Otto

Is Active Workbook ="ABC"
 

Otto,

Try something like

If ActiveWorkbook.Name < "ABC.xls" Then
' wrong file
End If

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Otto Moehrbach" wrote in message
...
Excel 2002, WinXP
I have a user-created menu item that is applicable to only one
file. That
menu item is created/deleted by code that is in that one file.
However,
other files may be open at the same time and I need to make
sure that this
one file, "ABC", is the active file before executing the menu
item code.
I thought that ThisWorkbook was always the active file but
it isn't.
ThisWorkbook is the file that holds the macro that is being
executed.
How do I check for the active file, as in:
If (the active file).Name < "ABC" Then MsgBox "Wrong File"
Thanks for your help. Otto

Is Active Workbook ="ABC"
 

Thanks Chip. I knew it had to be something simple. Otto
"Chip Pearson" wrote in message
...
Otto,

Try something like

If ActiveWorkbook.Name < "ABC.xls" Then
' wrong file
End If

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Otto Moehrbach" wrote in message
...
Excel 2002, WinXP
I have a user-created menu item that is applicable to only one
file. That
menu item is created/deleted by code that is in that one file.
However,
other files may be open at the same time and I need to make
sure that this
one file, "ABC", is the active file before executing the menu
item code.
I thought that ThisWorkbook was always the active file but
it isn't.
ThisWorkbook is the file that holds the macro that is being
executed.
How do I check for the active file, as in:
If (the active file).Name < "ABC" Then MsgBox "Wrong File"
Thanks for your help. Otto

Is Active Workbook ="ABC"
 

have you tried Windows("ABC.xls").Visible = True

--
Message posted from http://www.ExcelForum.com

Is Active Workbook ="ABC"
 

Hi Otto;

Use the call

ActiveWorkBook.Name

It might look something like this:

Sub Try ()

If ActiveWorkBook.Name = "MyWorkBookName" then
'do your menu stuff here
End If
End Sub


-----Original Message-----
Excel 2002, WinXP
I have a user-created menu item that is applicable to
only one file. That
menu item is created/deleted by code that is in that one
file. However,
other files may be open at the same time and I need to
make sure that this
one file, "ABC", is the active file before executing the
menu item code.
I thought that ThisWorkbook was always the active
file but it isn't.
ThisWorkbook is the file that holds the macro that is
being executed.
How do I check for the active file, as in:
If (the active file).Name < "ABC" Then MsgBox "Wrong
File"
Thanks for your help. Otto


.

Is Active Workbook ="ABC"
 

I responded but I haven't seen it posted. I'll try again. Otto

Thanks Chip. I knew it had to be something simple. Otto

"Chip Pearson" wrote in message
...
Otto,

Try something like

If ActiveWorkbook.Name < "ABC.xls" Then
' wrong file
End If

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Otto Moehrbach" wrote in message
...
Excel 2002, WinXP
I have a user-created menu item that is applicable to only one
file. That
menu item is created/deleted by code that is in that one file.
However,
other files may be open at the same time and I need to make
sure that this
one file, "ABC", is the active file before executing the menu
item code.
I thought that ThisWorkbook was always the active file but
it isn't.
ThisWorkbook is the file that holds the macro that is being
executed.
How do I check for the active file, as in:
If (the active file).Name < "ABC" Then MsgBox "Wrong File"
Thanks for your help. Otto