Sign in to follow this  
Followers 0
jaclaz

A request from the past

4 posts in this topic

A strange request :ph34r: , 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 :w00t: ) 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 by jaclaz
0

Share this post


Link to post
Share on other sites

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. :whistle:

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. :D

0

Share this post


Link to post
Share on other sites

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 :yes: , 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:

gw7ekylasa.jpg

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 :wacko: 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 :whistle: using the nice :thumbup lishi key cutter I own (and that I paid a fortune :().

jaclaz

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.