C
coder_arun
Hi,
I am creating a macro sheet using Excel 97 macro functions like:
English:
=WORKBOOK.SELECT("Sample")
=SELECT("R1C1:R10C2")
=RUN("Macro1")
=SELECT("R1C1:R10C2")
=FORMAT.NUMBER("dd-mmm-yyyy")
=RETURN()
Dutch:
=WORKBOOK.SELECT("Sample")
=SELECT("R1K1:R10K2")
=RUN("Macro1")
=SELECT("R1K1:R10K2")
=FORMAT.NUMBER("dd-mmm-jjjj")
=RETURN()
Spanish:
=WORKBOOK.SELECT("Sample")
=SELECT("L1C1:L10C2")
=RUN("Macro1")
=RETURN()
As you can see above for each langauge i have to generate diffren
characters for the macro
English:
R1C1
Italian:
R1K1
Spanish:
L1C1
The characters of the date format also changes for according to th
locale.
Could some one tell me how can i create language independent Macros i
Excel 97 (No VBA macros), such that i generate macros only in english.
And specify the language in some function as a parameter to excel.
Thanks in Advance
Aru
I am creating a macro sheet using Excel 97 macro functions like:
English:
=WORKBOOK.SELECT("Sample")
=SELECT("R1C1:R10C2")
=RUN("Macro1")
=SELECT("R1C1:R10C2")
=FORMAT.NUMBER("dd-mmm-yyyy")
=RETURN()
Dutch:
=WORKBOOK.SELECT("Sample")
=SELECT("R1K1:R10K2")
=RUN("Macro1")
=SELECT("R1K1:R10K2")
=FORMAT.NUMBER("dd-mmm-jjjj")
=RETURN()
Spanish:
=WORKBOOK.SELECT("Sample")
=SELECT("L1C1:L10C2")
=RUN("Macro1")
=RETURN()
As you can see above for each langauge i have to generate diffren
characters for the macro
English:
R1C1
Italian:
R1K1
Spanish:
L1C1
The characters of the date format also changes for according to th
locale.
Could some one tell me how can i create language independent Macros i
Excel 97 (No VBA macros), such that i generate macros only in english.
And specify the language in some function as a parameter to excel.
Thanks in Advance
Aru