ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Translation to International Excel 4 Macro (https://www.excelbanter.com/excel-programming/370086-translation-international-excel-4-macro.html)

coder_arun[_10_]

Translation to International Excel 4 Macro
 

I have a Excel 4 Macro sheet that looks like this:

Auto_Open
=ERROR(2;Recover)
=WORKBOOK.SELECT("Sheet 1")
=WINDOW.RESTORE()
=WINDOW.SIZE(82.5;42.75)
=WORKBOOK.HIDE("Macro1";TRUE)
=EDIT.COLOR(1;0;0;0)
=EDIT.COLOR(3;255;0;0)
=EDIT.COLOR(4;212;212;212)
=EDIT.COLOR(5;247;247;231)
=EDIT.COLOR(2;255;255;255)
=RUN("Macro5")
=DELETE.NAME("Auto_Open")
=WORKBOOK.SELECT("Sheet 1")
=SELECT("R1:R65536")
=COLUMN.WIDTH(;;;3)
=ROW.HEIGHT(;;;3)
=SELECT("R1C1")
=WINDOW.MAXIMIZE()
=RETURN()


Macro5
=WORKBOOK.SELECT("Sheet 1")
=SELECT("R2C1:R4C2")
=RUN("Macro1")
=SELECT("R2C3:R4C3")
=RUN("Macro2")
=SELECT("R2C3:R4C3")
=FORMAT.NUMBER("""$""###,###,##0.00")
=SELECT("R2C2:R4C2")
=FORMAT.NUMBER("dd-mmm-yyyy")
=SELECT("R1C1:R1C2")
=RUN("Macro3")
=SELECT("R1C3")
=RUN("Macro4")
=RETURN()

Macro1,Macro1,Macro3,Macro4 are formating macros...

How can i convert these macros into a "Excel 4 International Macro
format

Regards
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=57069



All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com