Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Case sensitivity of functions in Excel | Excel Worksheet Functions | |||
Differentiating Case Sensitivity in a Vlookup | Excel Discussion (Misc queries) | |||
Case sensitivity | Excel Programming | |||
VLookup & Case Sensitivity | Excel Worksheet Functions |