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

M

MichaelOfficer

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?
 
W

wayne

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-1059/saving-file-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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top