Save As macro

  • Thread starter Thread starter BigDave
  • Start date Start date
B

BigDave

Here is the macro I recorded for SaveAs in a workbook:
Application.CutCopyMode = False
ChDir "C:\Documents and Settings\XXXX\Desktop"
ActiveWorkbook.saveas Filename:= _
"C:\Documents and Settings\XXXX\Desktop\Joe Smith (ABCD) NM dp
6.7.05.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Click to expand...

In my workbook:

Joe Smith ABCD = A4
NM = G5

dp and 6.7.05 are not already in the workbook, but need to be in the
file name. Is there a way to alter the code above to (1)retrieve the
information already present in the workbook and (2) via macro, request
the other information?

The point is to click a button and have the file saved as* Joe Smith
(ABCD) NM dp 6.7.05.xls*
 
Back
Top