Open Outlook Macro With Excel VBA? [duplicate]
Possible Duplicate:
Call outlook VBA from Excel
I know about the Application.Run
method from Excel, with which I can open an E开发者_运维百科xcel macro from Outlook.
I need to switch the Excel.Application
object to Outlook.Application
and it doesn't work.
The error message is: "Method is not supported."
According to this thread, the only way to do this is to call a procedure stored in ThisOutlookSession
:
Set myOlApp = CreateObject("Outlook.Application")
myOlApp.MyProcedure
However, this seems unsupported by MS.
精彩评论