View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hari[_3_] Hari[_3_] is offline
external usenet poster
 
Posts: 157
Default "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