Here is the macro I recorded for SaveAs in a workbook:
In my 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
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
Bookmarks