Adam
www.rondebruin.nl
www.dick-clicks.com
--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.
"Adam" wrote in message
...
Hi,
I have a spreadsheet which has various macros in it. One
macro existing copies the spreadsheet as values only into
a new workbook and saves this onto the local disk
as "Workbook name " as at now hh:mm am/pm etc.
What I want it to do before it closes the activeworkbook
is to email me with the subject "Workbook name" as at
now, hh:mm.
Anyone know the code I can insert into my existing macro?
Thanks
Adam