Excel objects changing case

  • Thread starter Thread starter J Streger
  • Start date Start date
J

J Streger

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
 
What you describe can occur if you use a Keyword as a variable.

To avoid, don't use keywords as variables.

Regards,
Peter T
 
Add a line like this in your code:

Dim ThisWorkbook
(hit enter)

Then delete that line.
 
Back
Top