Language Indepedent XLM Macro

C

coder_arun

Hi

I have some XLM macros that are generated from my application, i hav
to generate the macros according to the locale
Example:

English:
=SELECT("R1C1:R10C1")
=RUN("Macro1")

Italian:
=SELECT("R1K1:R10K1")
=RUN("Macro1")

Spanish:
=SELECT("F1C1:F10C1")
=RUN("Macro1")

Is it possible to generate Language independent macros, i have hear
about some methods to do that... but not sure what they are...
Please do let me know.

Thanks in Advance
Aru
 
K

keepITcool

There are 2 types of macro sheets...

1. Microsoft Excel 4.0 macrosheet
a localized sheet, using localized functions and
localized references.

2. International MacroSheet
ALWAYS uses US english for functions and references.

you'll need the 2nd one. (International) for macros to work in all
languages.

you can copy the cells from xlm4 to intl (and vice versa).
functions are translated autom. BUT you'll have to review
"text" arguments carefully!

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


coder_arun wrote in
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top