Rename workbook upon closing

[Brian]

Hi,
Can I have my workbook renamed upon closing and make the name the date which
is found in cell al of sheet named "patrol log". Two twists to this request
is that (1) I want to make the name consist of a constant "Patrol Log" with
the date from the a1 cell following, ex: Patrol Log 10-18-04. (2). I do not
want to have a save as request performed because that ends up keeping the
original workbook around, I want a rename request performed so that the
original is not saved.

I hope someone can help
Thank You,
Brian

 

[Ron de Bruin]

Hi Brian

If you don't whant to save the orignal file you can do
a SaveCopyAs before closing

ActiveWorkbook.SaveCopyAs "Patrol Log " & Format(Now, "mm-dd-yy h-mm-ss") & ".xls"

Read Chip Pearson's site about Events
http://www.cpearson.com/excel/events.htm