Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Outlook attachment
Erin, I suggest you try:
set wkb=workbooks("myworkbook") strCopyName= "c:\folder1\folder2\file.xls" 'create the copy wkb.savecopyas strCopyName 'emailcode here '... 'delete the copy kill strCopyName keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "?B?RXJpbg==?=" wrote: I have a VBA module which will email the open spreadsheet as an attachment. I want to give the attachment a different name though. Currently, I'm doing a 'Save As' under the new name and then emailing it. This works okay for the email, but then I want the user put back under the original workbook name. Is there a way to do this without doing another saveas under the original file name? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open event does not run on Outlook attachment | Excel Discussion (Misc queries) | |||
Outlook attachment to network folder | Excel Discussion (Misc queries) | |||
Outlook attachment | Excel Programming | |||
Send Outlook Attachment within Excel | Excel Programming | |||
Email Attachment from Excel using Outlook. | Excel Programming |