Save As macro

[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

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*

 

[theDude]

Hi Dave!

This looks similar to another post of yours that I replied to:

http://www.excelforum.com/showthread.php?p=990999#post990999

You never responded to see if it worked out...

Let me know,
theDude

 

[BigDave]

Nice - thank you very, very much. I'll hook it up and let you know

 

[BigDave]

Worked great. Thanks!!