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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |
Reply |
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 |