In Excel 2003, how do I automate file naming/saving + date?
 

I receive an Email containing 2-3 daily takings reports for bookkeeping 2-3
times per week. I wish to automate the "save as" process to include the
date, because at the moment ALL reports inward have the same name.

Is there a small macro (or other process) I could insert into her "template"
to automate this process and de-stress both of us?

In Excel 2003, how do I automate file naming/saving + date?
 

On 07/16/2009 03:19 AM, MichaelOfficer wrote:
I receive an Email containing 2-3 daily takings reports for bookkeeping 2-3
times per week. I wish to automate the "save as" process to include the
date, because at the moment ALL reports inward have the same name.

Is there a small macro (or other process) I could insert into her "template"
to automate this process and de-stress both of us?

Try this site:
http://en.allexperts.com/q/Excel-105...date-stamp.htm

--
Wayne
glenmeadows.us
A democracy is nothing more than mob rule, where fifty-one percent of
the people may take away the rights of the other forty-nine. [Thomas
Jefferson]