Running Excel Macro from Outlook

[acp1]

I currently have a macro in Outlook that opens up the selected e-mail's attachment (CSV file) in Excel.... (works great!)

Is it possible to run an excel macro (already saved in the global XLA for excel) that then performs some additional work once this CSV has been opened by outlook?

I currently use one of two methods to open Excel files from outlook

Method 1:

Shell "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE " & FileName

Method 2:

'open up excel
Dim xlApp As Excel.Application
Set xlApp = New Excel.Application
xlApp.Visible = True
            
'open the attachment
Dim xlWorkbook As Excel.Workbook
Set xlWorkbook = xlApp.Workbooks.Open(FileName:=FileName, UpdateLinks:=False, ReadOnly:=False)

Thoughts?

 

[bensonsearch]

if its in the global part (accessable from any workbook you open) then you can call it in the code

ie Call mymacro

 

[acp1]

Tried including the "Call macroName" in my Outlook VBA and no luck...

Are there any other ways of calling an Excel Macro to execute from Outlook VBA?

 

[bensonsearch]

maybe try application.run(macroname)

 

[acp1]

Still nothing

At least this time it doesn't give an error.... just doesn't do anything :S

 

[bensonsearch]

have you tried this at the end of method 2?

only other way (kinda cheat) would be under the global this workbook place a call to the macro under workbook open, but this will do it every time you open excel weather you want it to or not