Excel Range name case sensitivity in VBA code
 

We have VBA code in an Excel workbook that assumes range names in Excel are
not case sensitive eg:
This workbook.worksheet ("Main").Range("Fimported").Value
is equivalent to:

This workbook.worksheet ("Main").Range("fimported").Value

This has been successfully deployed for many years in the Excel applications
we develop and market.

However, we have a computer with a Turkish customer where the code fails
because the code is case sensitive, but only on that computer!!

Has anyone ever experienced this and if so, what is the explanation behind
this particular computer behaving like this while every other we have
encountered is not case sensitive to range names?
Thanking you in advance.

Excel Range name case sensitivity in VBA code
 

Only a raw guess but try:
Computer Configuration\Windows Settings\Security Settings\Local
Policies\Security Options
set enabled

"Bruce" wrote:

We have VBA code in an Excel workbook that assumes range names in Excel are
not case sensitive eg:
This workbook.worksheet ("Main").Range("Fimported").Value
is equivalent to:

This workbook.worksheet ("Main").Range("fimported").Value

This has been successfully deployed for many years in the Excel applications
we develop and market.

However, we have a computer with a Turkish customer where the code fails
because the code is case sensitive, but only on that computer!!

Has anyone ever experienced this and if so, what is the explanation behind
this particular computer behaving like this while every other we have
encountered is not case sensitive to range names?
Thanking you in advance.

Excel Range name case sensitivity in VBA code
 

Try deleteing some of the registry entries. Windows will automatically will
recrete the entries with default values. This one is a good suspect.

HKEY_CURRENT_USER\Software\Microsoft\Office\Common

Does it happen with all logins on the bad PC?


Why is it always Turkey. The last problem I seen with workbooks that were
distributed to multuiple countries is a workbook from Israel had problems in
Turkey?????
"Bruce" wrote:

We have VBA code in an Excel workbook that assumes range names in Excel are
not case sensitive eg:
This workbook.worksheet ("Main").Range("Fimported").Value
is equivalent to:

This workbook.worksheet ("Main").Range("fimported").Value

This has been successfully deployed for many years in the Excel applications
we develop and market.

However, we have a computer with a Turkish customer where the code fails
because the code is case sensitive, but only on that computer!!

Has anyone ever experienced this and if so, what is the explanation behind
this particular computer behaving like this while every other we have
encountered is not case sensitive to range names?
Thanking you in advance.