Thanks, I learn somethin new everyday with this stuff.
Never knew about the 'ThisWorkBook' b4.

-----Original Message-----
BTW, it waould be a lot easier to use:

ThisWorkbook.Activate

to activate the workbook containing the macro.

--

Vasant


"slcark" wrote in
message
...

-----Original Message-----
I believe it is the Windows setting that controls the
behavior. In a Windows
Exlporer window:

Tools | Folder Options | View | Hide file extensions
for
known file types

--

Vasant



"sclark" wrote in
message
...
I ran into a problem the other day with Activating an
Open
workbook in Excel VB. I run this macro everyday,
and it
has no problem on MY pc, but fails on most others.
The
code is Workbooks("MyBook").Activate, where MyBook is
the
workbook that contains the macro. It fails on other
pc's
because the name MyBook is not fully qualified to
MyBook.xls. If I fully qualify it, it works on all
machines. Is there an XL setting somewhere that
controls
whether the fully qualified name is required or not?


.
Thanks for the reply. I tried that and it didn't work.
Not sure if I have to reboot or not (I havent) but it
still fails. Funny thing is that it will OPEN workbooks
without being fully qualified, but it won't activate
them. My other computer does both...I'm certain there
must be a setting somewhere, and the one you suggested
seemed like a likely candidate. I will keep searching.

Steve


.