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.