I would like to be able to create a macro that would take the text that is
entered into a cell, cat the current date to that text, then save the file
"as" that name and then send that same file as an attachment to a preselected
email address. All with one click on the tool bar.

Hi there Pat,

You need to post in the microsoft.public.excel.programming newsgroup. You
should also add information to your post such as what version you are
working with, what applications you would like to use (especially when it
comes to the emailing portion), what scope of workbooks you will be using
this on, what sheets and cells will you be looking at, where you would like
to save the file and what you want to do with the previous version (i.e.
close, delete, etc). Basically, more information is needed.

HTH

--
Regards,
Zack Barresse, aka firefytr
MsgBox "fire" & "fytr" & Chr(64) & "vba" & "express" & Chr(46) & "com"



"Pat Baratta" <Pat wrote in message
...
I would like to be able to create a macro that would take the text that is
entered into a cell, cat the current date to that text, then save the
file
"as" that name and then send that same file as an attachment to a
preselected
email address. All with one click on the tool bar.