translating 123 macros

Giganews Newsgroups
Subject: translating 123 macros
Posted by:  Bruce Kube (bku…
Date: Tue, 04 May 2004


I was wondering if there is anybody out there that can help me.  I
currently keep track of statistical data in Lotus 123 R9 and have macros
written to perform certain tasks.  My IT department is up grading my PC
to all microsoft and I need to convert these macros to the excel
equivalent.  here's what I need to do.

Each month of statistics has in a cell the month and year ie April 2004
in the 123 macro, when initiaited it takes the template filename
"Routbla and replaces the bla with the first 3 characters of the month
and saves the new file to the A:\ drive.  Can anyone tell me how to use
the VB macrowriter to accomplish this task.  Thank you.