Uniform and automated save feature... for excel (or word templates

[SooHunter]

I would like to know if ANY of the microsoft products (especially Excel
and/or word templates) can be designed with a Macro that saves an automated
file name. I would like to have some feature that will save the file with a
new (updated) file name. The plan is to use an excel file or word template
and have a simple "button style" macro which when selected can create its own
file name.

For example... user selects a Save Icon and the save as feature comes up
with a pre-determined name such as "2007-10-02-6am.xls"

This project will be used by many users, each require to save the file. I
hope there is a way to have the file name generated by a combiination of date
and shift (for example).

Any thougths or suggestions would be appreciated...

Thank you,
Tom

 

[Bob Phillips]

If you have your own button than just create a simple macro in Excel

Sub SaveIt()
Activeworkbook.SaveAs Format(Now,"yyyy-mm-dd hAM/PM")
End Sub

and assign the button to that macro

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[SooHunter]

Thank you Bob for your quick reply... unfortunately I don't fully understand
the process. Could you simplify including making the icon...

I can make simple macro's (in excel)... I wasn't sure where to start with
this one.

This has excited me even more than anticipated... I would love to know what
the process would be in MS Word as well...

Thank you so much...

TOM

 

[Bob Phillips]

To create a button, just select Tools>Customize. Select the Commands tab,
and in the Categories pane, scroll down to the Macros Category, then you
will see smiley face in the Commands pane. Drag that smiley up into one of
the existing toolbars. You will be asked to assign a macro, so assign the
one I gave you. Then Ok out.

You now have a button that you can use to fire your save macro.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)