Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel objects changing case
I've noticed that in a few instances the certain properties casing will
change. Such as a workbook whose 'ThisWorkbook' property has changed to 'thisworkbook' and the .Name property changed to .name. It all still works, but is just annoying to see as I use the auto-capitalization to make sure I type my code correctly. Is there any way to fix this. I tried a find/replace all but doesn't work. I've seen this same behavior for enumerations as well. Thank you. -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 User of MS Office 2003 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel objects changing case
What you describe can occur if you use a Keyword as a variable.
To avoid, don't use keywords as variables. Regards, Peter T "J Streger" wrote in message ... I've noticed that in a few instances the certain properties casing will change. Such as a workbook whose 'ThisWorkbook' property has changed to 'thisworkbook' and the .Name property changed to .name. It all still works, but is just annoying to see as I use the auto-capitalization to make sure I type my code correctly. Is there any way to fix this. I tried a find/replace all but doesn't work. I've seen this same behavior for enumerations as well. Thank you. -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 User of MS Office 2003 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel objects changing case
Add a line like this in your code:
Dim ThisWorkbook (hit enter) Then delete that line. J Streger wrote: I've noticed that in a few instances the certain properties casing will change. Such as a workbook whose 'ThisWorkbook' property has changed to 'thisworkbook' and the .Name property changed to .name. It all still works, but is just annoying to see as I use the auto-capitalization to make sure I type my code correctly. Is there any way to fix this. I tried a find/replace all but doesn't work. I've seen this same behavior for enumerations as well. Thank you. -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 User of MS Office 2003 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing from lower case to upper case | Excel Discussion (Misc queries) | |||
Changing from upper case to lower case | Excel Discussion (Misc queries) | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
Changing Upper case to Proper Case | Excel Worksheet Functions | |||
changing lower case to upper case | Excel Discussion (Misc queries) |