I want to create a macro that will save a Workbook with the origina
workbook name at the start and then the current date and other tex
behind.

For example if my workbook is named

"Financial Model.xls"

I want the macro to add two parts to this file name,
- first, the current date in this format 2004-08-11,
- second, text such as "Final"

Therfore, in this example I want:
- "Financial Model.xls" to be saved as . . .
- "Financial Model, 2004-08-11, Final.xls"

I'm using this in combination with a macro that will convert all dat
in the spreadsheet to values only (done through copy, paste special
values)

Any help is much appreciated

--
Message posted from http://www.ExcelForum.com