Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Casing" the strings for smooth code running
Don't know.
What does WorkBooks("abc.xls").Activate do -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |