|Subject:||translating 123 macros|
|Posted by:||Bruce Kube (bku…@path.som.sunysb.edu)|
|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.