Excel Macro - Pretty Pretty Please..with cherries on top

[rbenak]

I need a macro that opens a workbook, refreshes the data(it comes from an external source)sends the wb as an attachment to multiple recipients, then closes.

 

[Jooky68]

Did you start the coding and are having trouble with it?

 

[rbenak]

Yeah, This is what I have...

Sub refresh()
Workbooks.Open "Book2.XLS"
ActiveWorkbook.RunAutoMacros xlAutoActivate

ActiveWorkbook.RefreshAll
ActiveWorkbook.SendMail Recipients:="Richard Benak"

End Sub

 

[rbenak]

Am I totally off on this?

 

[lespaul]

Have you recorded a Macro and done everything in Excel and then look at the code generated?

Leslie

 

[rbenak]

I don't know how to record a macro to have the macro auto run.

 

[lespaul]

Don't worry about the auto run yet, go to Tools - Macro - Record New Macro then do all the steps needed to accomplish your goals:

"opens a workbook, refreshes the data(it comes from an external source)sends the wb as an attachment to multiple recipients, then closes"

Once you do all the above, stop the recorder, go to Tools - Macros then edit the macro you just recorded and you will have all the code needed to do the above. then you can worry about getting it to auto open!