Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Can any one give me pointers how to write "International Excel 4 Macro" file (xlm files). My current macro sheet looks like : 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() I want to change to above to "International Excel 4 Macro". Any guidance will be of gr8 help... Thanks in Advance Arun |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
International Excel 4 Macro | Excel Discussion (Misc queries) | |||
Translation to International Excel 4 Macro | Excel Programming | |||
Excel 4 International Macro | Excel Programming | |||
Creating Excel 4 International Macro Sheet | Excel Programming | |||
Creating Excel 4 International Macro Sheet | Excel Programming |