"Casing" the strings for smooth code running
 

Hi,

I have a file lets say "AbC.xls" inactivated and if I write

Windows("abc.xls").activate

I get a Runtime error. Racked my mind in the last few days and posted it in
NG also. Finally I understood that I have to specify the filename with the
correct case and once I say
Windows("AbC.xls").activate

my code will work out to be fine. Something more strange. My colleagues have
the same Excel 2002 version as mine. If I run the same code in their
Workstations , then in some of my colleagues computer there will be no need
for correct case specification and the code will work out alright.How can
the "partiality" be explained.

Regards,
Hari
India

"Casing" the strings for smooth code running
 

Don't know.
What does WorkBooks("abc.xls").Activate do

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

"Casing" the strings for smooth code running
 

Hi Brian,

Im activating the workbook abc using this statement so that subsequently I
could perform some selective copy,paste operations

Regards,
Hari
India

"BrianB " wrote in message
...
Don't know.
What does WorkBooks("abc.xls").Activate do ?


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