0

Possible Duplicate:
Call outlook VBA from Excel

I know about the Application.Run method from Excel, with which I can open an Excel 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."

Martijn Pieters
  • 963,270
  • 265
  • 3,804
  • 3,187
MrPropper
  • 3
  • 1
  • 2

1 Answers1

1

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.

JimmyPena
  • 8,630
  • 6
  • 42
  • 64
JMax
  • 25,301
  • 12
  • 66
  • 87