Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting a text strings but omitting preceding "A" or "The" | Excel Worksheet Functions | |||
=IF function, reference problem to "text strings" in Data Validati | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Looking for VB code to test for "RING" , "BUSY" disconnects or other signals | Excel Programming |