Call Excel Macro from Outlook
 

Hi
How do you call an excel macro from Outlook? I have an excel macro
that relies on an email I get everyday, so I have a macro in Outlook
that copies the excel attachment to a certain folder. I would then
like that macro to open up a workbook in Excel that has my macro in
and autorun it without me having to open it manually. Is this
possible?

Thanks,
Simon

Call Excel Macro from Outlook
 

Simon, try something like this:
Sub CallExcelMacro()
Dim eApp As Excel.Application
'Note: Must have set reference to:
'Microsoft Excel 11.0 Object Library
'This is accessed in the VBE Editor
'Under Tools - References...
Set eApp = GetObject(,"Excel.Application") 'Assumes Excel is open,
'Use CreateObject if Excel is not open.
eApp.Run "HelloWorld" 'Runs the subroutine name "HelloWorld"
End Sub

Let me know if you have problems.

--
Charles Chickering

"A good example is twice the value of good advice."


" wrote:

Hi
How do you call an excel macro from Outlook? I have an excel macro
that relies on an email I get everyday, so I have a macro in Outlook
that copies the excel attachment to a certain folder. I would then
like that macro to open up a workbook in Excel that has my macro in
and autorun it without me having to open it manually. Is this
possible?

Thanks,
Simon

Call Excel Macro from Outlook
 

Brilliant thanks Charles, I will try it out and let you know how i get
on! Simon