ExcelBanter

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

[email protected]

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


NickHK

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




coder_arun[_11_]

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


NickHK[_3_]

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




Jim Rech

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