![]() |
International Excel 4 Macro
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 |
International Excel 4 Macro
Can't you convert it modern VBA ?
NickHK wrote in message oups.com... 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 |
International Excel 4 Macro
No its not possible to convert to VBA... i have to convert it to "Excel 4 International Macro" format. -- 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 |
International Excel 4 Macro
OK then, but I guess that's why people not are able to answer your recent
posts. NickHK "coder_arun" ¼¶¼g©ó¶l¥ó·s»D:coder_arun.2cdisr_1155296406.0828@e xcelforum-nospam.com... No its not possible to convert to VBA... i have to convert it to "Excel 4 International Macro" format.. -- coder_arun ------------------------------------------------------------------------ coder_arun's Profile: http://www.excelforum.com/member.php...o&userid=33811 View this thread: http://www.excelforum.com/showthread...hreadid=570699 |
International Excel 4 Macro
See my response in the Misc group.
-- Jim "coder_arun" wrote in message ... | | No its not possible to convert to VBA... i have to convert it to | "Excel 4 International Macro" format.. | | | -- | coder_arun | ------------------------------------------------------------------------ | coder_arun's Profile: http://www.excelforum.com/member.php...o&userid=33811 | View this thread: http://www.excelforum.com/showthread...hreadid=570699 | |
All times are GMT +1. The time now is 10:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com