translating 123 macros

  • Thread starter Thread starter Bruce Kube
  • Start date Start date
B

Bruce Kube

Hi,

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.
 
You can use something like this to move and/or rename the file.
Sub movefile()
OldName = "C:\foldername\filename.xls"
NewName = "C:\newfolder\newfilename.xls"
Name OldName As NewName
End Sub
 
Back
Top