macro to email attachment - without saving first

Hi there,

I have a macro which updates a spreadsheet, it then creates an email with the spreadsheet as an attachment for sending out.

I obtained the code to do this from a previous thread:
http://www.excelforum.com/excel-prog...ice-email.html

Here is the code I am using for the email part of the macro:

Please Login or Register  to view this content.

The trouble is, the file that it attaches to the email is the last saved version - not the version with the updates. I don't want the macro to do a file save first, as I may not want it to over-write the existing file on the disk. But I do want it to set up the email for sending the new version out.

This is using Excel 2007.

Any ideas, please?

Thanks!
ssu95bm

Why not save it first with a different name?

Why not have the macro save the active file with the updates under a different name i.e. put Email in front of the file name? Then your original will not be overwritten.