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


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*


--
BigDave
------------------------------------------------------------------------
BigDave's Profile: http://www.excelforum.com/member.php...fo&userid=7741
View this thread: http://www.excelforum.com/showthread...hreadid=377138