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?