excel/outlook runtime error 440

Good morning,

Not sure if this belongs here or not but it has to do with outlook and ExceL. I have A script in outlook that when a trigger email is sent by me it runs a macro in an excel spreadsheet that is already open. However, I always get run time error 440 method run of object aplication failed. Any help would be apreciated below is my script in outlook. thanks!


Sub ExcelMacro(MyMail As MailItem)

Dim path As String
Dim eApp As Excel.Application

Set eApp = GetObject(, "Excel.Application")
With eApp
path = "M:\Sam\Ear\Automated Queries\Add-on Promo.xlsm"
eApp.Run "'Add-on Promo.xlsm'!RunAllMacros"

End With
End Sub

The only way this will work is if you either A) only have this one workbook open at all times or B) you cycle through the open workbooks and explicitly pick out the one your want.

If you only have this workbook open, your code is correct except you won't need to define the path of your workbook (as it's being taken from an open instance). So, troubleshooting:

Is the macro in your file in it's own module and is it a Public Sub?
Is the filename / name of the macro in your excel file correct compared to your outlook code?
Do you have a reference to Microsoft Excel Object Library in your Outlook vba?