Excel Macro Conversion

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

Hi,

I'm going to be teaching Excel VBA to an organization who
currently uses the older Excel macro language. I know
Excel and I know VBA and but I don't the pre-VBA
language. The company has emailed me a workbook that
contains a sales spreadsheet. Their goal is to convert
the older macros to VBA. I'm looking at the spreadsheet
now and I don't see any macros except this long string out
to the side. Looks like this:

/WTC{HOME}{PGDN}{GOTO}A18~{GOTO}A20~/WTH{GOTO}A19~{END}
{DOWN}{DOWN}@DATE({?},{?},{?})~{RIGHT}{?}{RIGHT}{?}{RIGHT}
{?}{RIGHT}@DATE({?},{?},{?})~{RIGHT 3}{?}{DOWN}{BIGLEFT}
~/XC\E~

Is this an older Excel macro? If not, how do I find these
older macros? And where can I go to learn more about this
older language to help the conversion to Excel VBA? Is
there a tool that converts older Excel macros to VBA?

Thanks for any information you have!!

Jerry
 
You're looking at old Lotus macro code. Unfortunateily, there's no
conversion utility out there (AFAIK), and instead of rewriting this macro,
it'd be better to understand what it did and/or what the user wants it to
do, then write it from scratch.
IMHO
Bob Umlas
Excel MVP
 
I agree with Bob Umlas, it would be better to understand the macro then
re-write it from scratch.

If you want to understand the code, then get a copy of Lotus 123 release 4
which has all the help files on both the older macros (\WTC etc.) and the
newer ones (anything inside curly brackets {HOME} etc.). And by newer ones
I mean before LotusScript.

There may be a conversion facility in one of the newer versions of 123 that
converts these old macros to LotusScript which is basically VBA but using
the Lotus 123 object model instead of Excels. That may be the best place to
start re-coding from.

Harlan Grove is your man for advice on all this stuff.

P
 
Back
Top