UCase() - internationalization

[ScrewBalll]

Hi There,
I've been working on an Excel app which works fine when the user has the English verison of Office installed, but problems arise when a foreign version is used.

The main problem seems to lie in some of the functions contained within the VBA object library - in particular the UCase() function, this isn't recognised on a French users PC.

Is there an easy way around this; i.e. by forcing the code to use the English vba library? or setting up the users pc for that one file to operate as on English settings.

Any help would be muchly appreciated

Simon

 

[PHV]

No problem at all with the references on the French users PC ?
When in VBE menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ScrewBalll]

Thanks for the quick response.

It appears that the reference is correct. But I can't determine whether the VBA Libarary reference is perhaps an international version rather then English.

I read somewhere that some of the string literal functions such as UCase may not work on international setups. This leads me to believe that it is a library reference problem, but I can't change the refernece to test it as it's in use.

 

[ScrewBalll]

There was a missing refernece to the Outlook library. Changing this solved the problem, it was a bit unexpected though as the UCase() function has nothing to do with the Outlook library. Ah well.

Cheers for your help.

 

[PHV]

it was a bit unexpected
Not for me
The way I suggest to avoid this problem on the future is to use late binding.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886