I writing VBA code to manipulate information excel. I want my code to
be able to run for people using MS Office in languages other than
English. I want to cover the main languages at this point and am not
too worried about languages requiring double character sets. The
languages that are supported in Windows 2000 English edition.

I am using Office 2000 but would also only use features available in
VBA Office 97 so would like it to work with that as well.

1) Does the VBA code needs to be specified differently in different
languages to work correctly in those languages?

2) Also I need to know how to translate any commands I may need to use
in my code Like setting a cart series formula a value.

Series.Formula = “=SERIES(,,Sheet1:$A$1;A$$20,1)”

I am guessing this won’t be the same in say German

It may possible be:

Series.Formula = “=REIHE(,,Sheet1:$A$1;A$$20,1)”

So in that instance I can’t test it because I don’t have the German
version of Excel.

I am also not sure that the VBA part “Series.Formula” will work in
German. So I am not sure if I can refer to objects like “Application”
or “Application.ActiveSheet” etc or need to translate those. I am
guessing that VBA looks after that internally but again I can’t test
it.

I did download a MS Command Translator application (Which is an MS
Access database that translates commands). I guess it only translates
commands within particular applications not VBA


3) If VBA does need to be defined differently how can I set up an
environment to test my applications? Purchasing the software for each
language would be too difficult and expensive.

I noticed there is an Office Multilingual / Multilanguage pack for
Office 2000 but don’t know if this will allow me to test my
applications as if I was in the other language.

4) If I do need Office Multilingual / Multilanguage pack for Office
2000 which part of it do I need to look at or install.

5) If I do need to purchase a multi lingual pack where can I get an
Office 2000 version?

"Series.Formula" and the rest of the internal commands WILL WORK IN
GERMAN!!! I have seen webs sites in german that do show this.

however I am unsure about: “=SERIES(,,Sheet1:$A$1;A$$20,1)” 
the german excel might accept the english functions (I have no
experince with that).
*IF* they do then no work needs to be done, If not then you will have
to translate, however i supsect that there may be a hidden function in
VBA that will do this translation, assuming that german excell does
not accept english commands.

hope this helps.

Thanks for your comment. Yes, In the meantime I also work that part
out. I also figured out how to get around the issue. What I found was
that the ="SERIES(" part of the command is in the native language so
in German it was "=DATENREIHE(". I would still like to find out where
I can get a translation of these types of commands and references like
in Germany they use Z1S1 instead of R1C1. It would be nice to find
transaltions for a languages.