Save As with specific format

[BigDave]

I need to create a Save As macro, activated by a button, that will take some information that is already contained in specfic cells of a workbook to create a specific file name. Here is an example of the file name:

Smith (ABCD) BB abc 3.11.05 where...

Smith is last name contained in cell A1
ABCD is the employee ID which will need to be entered manually
BB is a project code contained in cell B2
abc is auditors initinals to be entered manually
3.11.05 is the date the file was saved

[theDude]

Hi Dave!

This macro should work for you...

Please Login or Register  to view this content.

Hope this helps,
theDude