View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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