Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account


Photo

A request from the past

- - - - -

  • Please log in to reply
3 replies to this topic

#1
jaclaz

jaclaz

    The Finder

  • Developer
  • 14,289 posts
  • OS:none specified
  • Country: Country Flag
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...s.aspx?id=19243
http://support.micro...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, 09 July 2012 - 06:40 AM.



How to remove advertisement from MSFN

#2
Tripredacus

Tripredacus

    K-Mart-ian Legend

  • Super Moderator
  • 9,769 posts
  • OS:Server 2012
  • Country: Country Flag

Donator

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.co...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
MSFN RULES | GimageX HTA for PE 3-5 | lol probloms
msfn2_zpsc37c7153.jpg

#3
jaclaz

jaclaz

    The Finder

  • Developer
  • 14,289 posts
  • OS:none specified
  • Country: Country Flag

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:
Spoiler


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.micro...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

#4
Tripredacus

Tripredacus

    K-Mart-ian Legend

  • Super Moderator
  • 9,769 posts
  • OS:Server 2012
  • Country: Country Flag

Donator

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.c...xcelnames08.asp

:unsure:
MSFN RULES | GimageX HTA for PE 3-5 | lol probloms
msfn2_zpsc37c7153.jpg




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users



How to remove advertisement from MSFN