#1
|
|||
|
|||
Help with Excel Macro
I've copied this macro from a coworker and I need to change it so that it will send the (most current) file that I just edited as an attachment in the email that the macro is already sending out. The macro saves the current file in a specific folder with just a time stamp to seperate the files. I know next to nothing about macros so any help would be greatly apreciated.
Code:
Last edited by macropod; 03-31-2013 at 11:24 PM. Reason: Added code tags & formatting |
#2
|
||||
|
||||
Hi Cait783,
From my reading of the code, it saves the workbook, then sends it as an attachment. In that case, the attachment should always be the most recent file in the folder. In other words, it already does what you say you want it to. PS: When posting code, please post formatted code, using the code tags. They're on the 'Go Advanced' tab.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
vba excel |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
using macro or vba in excel | jassie | Excel Programming | 1 | 03-22-2012 10:39 PM |
Macro Excel | Il_Fabietto | Excel Programming | 3 | 07-28-2011 02:40 AM |
Macro: chart from excel into PP as objects | Jazz43 | PowerPoint | 0 | 03-05-2011 09:06 AM |
Excel macro (vba) | HuaMin | Excel | 2 | 03-22-2010 08:11 PM |
Help! for using an appropriate function/Macro in Excel | pawan2paw | Excel | 1 | 06-04-2009 12:28 PM |