A request from the past

[jaclaz]

A strange request , I know.

I have to (actually would like to) write a small set of Macro's (NO, NOT Excel VBA) to manage some textual data.

I have my reasons to use Excel Macro's (and no - again - NOT Visual Basic macros), basically the intended spreadsheet will not be used in Excel, but rather in SPREAD32.

I have found the "base references", i.e. the Excel Macro (for Macintosh ) docs and the help file macrofun.hlp.

http://www.microsoft.com/en-us/download/details.aspx?id=19243

http://support.microsoft.com/kb/128185/en-us

As always happens these show the actual command syntax but provide no or very little examples.

So I am looking for some examples (already written Macro's, related tutorials with examples, etc.).

Of course googling today will give as result 9999 VBA related pages an 1 (maybe) actually Macro related.

So, if anyone has some "old links", Wayback Machine bookmarks, etc. I would be very interested in them.

jaclaz

Edited July 9, 2012 by jaclaz

[Tripredacus]

Clicking through some thing, it seems that these old Excel macros used something called "XLM" format saved into an .xlm file. Not to be confused with XML.

Anyways, it looks like XLM macros were platform independent and allowed you to use them in both Windows and Macintosh versions of Excel.

I found this link:

http://plymdesign.com/microsoft-excel/macros-for-macintosh-excel-2008-using-xlm/

My search terms:

XLM Macros
Excel 4.0 macro language

I hope this isn't what you were looking for... since... it would be strange to find something for The Finder. Its like the Keymaster going to the hardware store to copy a key.

[jaclaz]

I hope this isn't what you were looking for... since... it would be strange to find something for The Finder. Its like the Keymaster going to the hardware store to copy a key.

Well, it is , in the sense that it is a "tip of the iceberg", a single, rather simple 23 lines macro using a handful of functions.

It is like giving half a thimble of water to someone that has just crossed the desert (but much better than nothing ).

I was hoping to find some place like our own:

MSFN Forum

> Coding, Scripting and Servers

> Programming (C++, Delphi, VB/VBS, CMD/batch, etc.)

corner where HUNDREDS of small batches/ .vbs's can be found.

But I have anyway to do a public FACEPALM:

because, while experimenting I found an issue with a Macro function (it turned out it was not yet implemented in Spread32), so I contacted Stephen Bye, the nice Author of Spread32, and he advised me to check the actual Spread32 forum:

http://spreadce.freeforums.org/

where OBVIOUSLY quite a few snippets are discussed/presented.

To add to the list of MS documentation, he also pointed me to the

http://support.microsoft.com/kb/143466/en-us

(though it contains more or less the same things as the previously posted ones).

About keys, JFYI , I usually "read" keys visually, learn them by heart. and can normally make a duplicate of one quickly without the original using the nice lishi key cutter I own (and that I paid a fortune ).

jaclaz

[Tripredacus]

maybe find something useful...

http://support.microsoft.com/kb/97522

These may require login to Google account:

My link

My link

You can try other things to search for in Groups.

Another search term that I stumbled across:

XL4 macro

http://www.jkp-ads.com/articles/excelnames08.asp