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

--
coder_aru
-----------------------------------------------------------------------
coder_arun's Profile: http://www.excelforum.com/member.php...fo&userid=3381
View this thread: http://www.excelforum.com/showthread.php?threadid=56783

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
<news:<coder_arun.2bynm3_1154603040.2436@excelforu m-nospam.com


Hi

I have some XLM macros that are generated from my application, i have
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 heard
about some methods to do that... but not sure what they are...
Please do let me know.

Thanks in Advance
Arun