VBA case-sensitive under Spanish regional settings?

[Paul Leonard]

From RLW, one of our support engineers:

============================
We have two .xla files, which we compile, protect, and save, and ship to our
customers. Both files are loaded in our solution. Foo.xla has a reference to
Bar.xla, and Bar.xla contains several functions with Pascal-case names, such
as "RclLockExist", that are called from Foo.xla. The code in Foo.xla calls
the function using all lower-case, as in "rcllockexist". The VBA editor does
not auto-correct this case mismatch across references, but since VBA is not
case-sensitive, our system generally runs just fine in several parts of the
world.

Several customers in Spain trying to run the product using Spanish regional
settings, get a "Compile error in hidden module" error. After unprotecting
the modules in Foo.xla and trying to compile, the error is on the call to
"rcllockexist", an undefined function or variable. If we change the case of
the call to "RclLockExist", then everything compiles again and runs just
fine. Alternatively, if we set these customer's regional settings to U.S.
English, the problem will not occur, but this is not a viable long-term fix
for these Spanish customers.

Has anyone heard of VBA becoming case-sensitive under Spanish regional
settings?

Thanks.
============================


This was reported as happening in several versions of Excel.

Thanks,
ptl

 

[Peter Huang [MSFT]]

Hi

Based on simple test, it seems that the VBA code will be case-insensitive
under Spanish regional in windows xp+sp2,Office 2003.
To make the problem more clear, can you help to build a simple reproduce
sample together with detailed reproduce steps and send to me via removing
"online" from my email address.

I appreciated your efforts!
Thanks!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.