Saving a shhet with given date

[Ed Davis]

I would like to save a file using a date the is a cell example follows:

In cel A2 is the date 04/02/07 and would like to create a macro to save the
file as 040207. This need to be a macros as my employees are not very savvy
with computers. And when a human makes a mistake it could be dangerous.

I do know how to create macros and my sheets have hundreds of the. When I
used Lotus I was able to do this but for the past several years I have been
looking to do this is Excel.

Thanks in advance.

 

[Guest]

You can do this with a Workbook_BeforeSave event.