View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan Williams[_2_] Dan Williams[_2_] is offline
external usenet poster
 
Posts: 1
Default XLM Resources? (XL4/Excel 4)

I may be taking over an old XLM/Excel 4 macro application for a year
or two until it is converted (by someone else, to a non-Excel
platform). It is HUGE (~50 Meg of code and tables).

I figure I should ask what resources exist for this left-behind
language. Through these newsgroups, I have already learned of and
acquired the following:
____________________________

The book--I managed to get a used copy via Amazon.com:

Chris Kinata and Charles W. Kyd
"Complete Guide to Microsoft Excel Macros"
Microsoft press 1993
ISBN 1-55615-526-3
____________________________

The help files, downloaded from Microsoft:

From: Dave Peterson
Subject: Does anyone use XLM?
Newsgroups: microsoft.public.excel.programming
Date: 2001-03-26 14:58:05 PST

http://www.microsoft.com/downloads/r...eleaseID=12917
macrofun.exe - 697 Kb

http://www.microsoft.com/downloads/r...eleaseid=12916
Macro97.exe - 513 Kb
____________________________

I have also read a newsgroup discussion of pausing and resuming XLM
macros in post-XLM versions of Excel:

From: John Green
Subject: Help needed by old retired programmer
Newsgroups: microsoft.public.excel.programming
Date: 2000-09-16 20:53:42 PST

http://groups.google.com/groups?hl=e...%40cppssbbsa04
____________________________

Plus, I wrote a VBA macro that parses and indents complex XLM
statements so I can read them, e.g. taking =IF(F55=TRUE,
ALERT(IF(Memos_Added =1, "THE 1st MEMO NAME", "THE 2nd MEMO NAME")&"
ALREADY EXISTS. "&IF(Memos_Added=1, "RE-ENTER THE NAMES.", "RE-ENTER
2nd NAME."), 2), GOTO(E61))...

....and pasting it into Word as this:


IF F55=TRUE Then
ALERT(
IF Memos_Added =1 Then
"THE 1st MEMO NAME"
Else
"THE 2nd MEMO NAME"
End If
&
" ALREADY EXISTS. "
&
IF Memos_Added=1 Then
"RE-ENTER THE NAMES."
Else
"RE-ENTER 2nd NAME."
End If
,2)
Else
GOTO(E61)
End If
____________________________


Even if this application turns out to be too much for me and they have
to hire someone to maintain it, I may be still involved in documenting
how it works.

Is that about it for resources? I'm wondering if there there's some
sort of "User Group of the Damned" out there. (Or a "User Group of
the Elite" -- diehards who stuck with XLM rather than switching to
VBA?)

Dan Williams