Language Indepedent XLM Macro

  • Thread starter Thread starter coder_arun
  • Start date Start date
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
 
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
 
Back
Top