"Casing" the strings for smooth code running

H

Hari

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
 
H

Hari

Hi Brian,

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

Regards,
Hari
India
 
Top