VBA on mac excel 2011

0
votes

I'm trying to open a specific email within excel using VBA macro. The problem I've is that I'm not able to run Outlook.Application becouse there is no Outlook 14.0 library installed in my VBA References. I think it depends becouse I'm running into a MAC. The code where i get activex error is this:

Dim OlApp As Outlook.Application
Set OlApp = CreateObject("Outlook.Application")

Any idea to download from somewhere the MSOUTL.OLB mac version and make this to work?

1
excelvbaoutlook

1 Answers

0
votes

I've discovered that Excel 2011 for OSX has not .NET support so it's not possible to load "Outlook.Application" library that is a Windows prerogative.