VBA code that works with different languages

[Berlie]

I have a VBA project that works just fine on an English language computer. People have tried to use it on computers that use a different language and it does not work. I am assuming that certain parts of the code that are referencing English language items and such are giving errors when trying to reference them in different languages.

Without having access to computers that use different languages is there anyway I can look through my code and find the problem areas and look up what the equivalent would be in another language? Basically so I can make custom versions that will work for those using another language?

My project is somewhat large with 3 different userforms and macros so its a lot of code I would need to look at.

Any help appreciated.

 

[PHV]

Which application ?
Since office2000 the VBA project use the US verbiage despite your locale.

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

 

[Berlie]

Sorry, MS Word.

What things should I look out for in my code then that may be causing these problems?

 

[PHV]

Which version ?
Which error ?

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

 

[Berlie]

Well thats my problem.. I don't know. The people that are telling me there are errors aren't being very helpful besides just saying "it don't work".

If I knew what the error was I could probably find the problem code and why it was having trouble in other languages. Without being able to test it myself on computers using different languages and without getting any help from those that say it doesn't work I am left blindly looking through the code trying to figure out which parts might be giving errors on non English computers.

 

[EBGreen]

So if you extend your difficulties out one step further, we don't even have the code to look at.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[TonyJollans]

Hi Berlie,

Like everybody else, I'm completely in the dark here and can't solve your problem for you but a couple of very general pointers might help.

The VBA language and all the properties and methods of objects are the same in all languages. There are two areas where language can make a difference.

One is in string variables or literals which are used as names, for example CommandBars("Standard") - the Standard commandbar is not called "Standard" in all languages. Similarly (in Excel) "Sheet1" is not called "Sheet" anything in some languages.

The other area is in regional settings; if a comma is used as the decimal point then a semicolon is likely to be used as the list separator (in application syntax, not VBA itself) - in code this is again likely to be inside a string variable or literal. This affects things like Excel formulae.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[