Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Language Indepedent Macro
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 -- 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=56779 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Language Indepedent Macro
Hi Arun,
There's no need for these macros, Excel will convert the date format for you. You can perform this by changing your regional setting to a different country and see the result for yourself. HTH KM "coder_arun" wrote: 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 diffrent characters for the macro English: R1C1 Italian: R1K1 Spanish: L1C1 The characters of the date format also changes for according to the locale. Could some one tell me how can i create language independent Macros in 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 Arun -- coder_arun ------------------------------------------------------------------------ coder_arun's Profile: http://www.excelforum.com/member.php...o&userid=33811 View this thread: http://www.excelforum.com/showthread...hreadid=567799 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Language Indepedent Macro
Arun,
In VBA you can write the functions in English, and Excel automatically manages the localization. So you write Range("A1").Value = "=IF(G1="","",VLOOKUP(G1,A:B,2,FALSE))" and Excel would create say OM(G1="";"";LETARAD(G1;A:B;2;FALSKT)) in a Swedish version. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "coder_arun" wrote in message ... 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 diffrent characters for the macro English: R1C1 Italian: R1K1 Spanish: L1C1 The characters of the date format also changes for according to the locale. Could some one tell me how can i create language independent Macros in 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 Arun -- coder_arun ------------------------------------------------------------------------ coder_arun's Profile: http://www.excelforum.com/member.php...o&userid=33811 View this thread: http://www.excelforum.com/showthread...hreadid=567799 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change German language data into Eglish Language in a colum | Excel Discussion (Misc queries) | |||
language support in excel sheet using a third party language tool | Excel Worksheet Functions | |||
Recommendation for XML Macro language person trying to convert to | Excel Programming | |||
Macro Language | Excel Programming | |||
How to change the excel format from language to language? | Excel Discussion (Misc queries) |