International Excel 4 Macro

[[email protected]]

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

[NickHK]

Can't you convert it modern VBA ?

NickHK

<[email protected]> wrote in message
news:[email protected]...
> 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
>

[coder_arun]

No its not possible to convert to VBA... i have to convert it to
"Excel 4 International Macro" format..

[Jim Rech]

See my response in the Misc group.

--
Jim
"coder_arun" <[email protected]> wrote
in message news:[email protected]...
|
| 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
|

[NickHK]

OK then, but I guess that's why people not are able to answer your recent
posts.

NickHK

"coder_arun" <[email protected]> ¼¶¼g©ó¶l¥ó·s»D:[email protected]...
>
> 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
>