View Single Post
  #1   Report Post  
Old February 22nd 21, 07:30 PM posted to microsoft.public.excel.programming
lamar spalding lamar spalding is offline
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2021
Posts: 1
Default Activex component cannot create object Excel 365 for mac

I have excel 365 on my PC and the VBA for sending email from excel to outlook works perfectly. I transferred the same code to excel 365 for mac and it will not run. Apparently the Outlook object reference is missing in the references library. I cannot find the Outlook Object in the references library and the library shows a message Missing: Microsoft Outlook 16.0 Object library

So I tried creating outlook as an object but it still fails (BTW I am not a programmer, found this on the web). The Microsoft Office 16.0 Object and Microsoft Excel 16.0 Object libraries are checked in references.

Send email
Dim olApp As Object
Set olApp = CreateObject("Outlook.Application")

this fails with error "Activex component cannot create object"

On my PC the following code works and the OutlookObject is in the reference library

Dim olMail As Outlook.MailItem
Set olMail = olApp.CreateItem(olMailItem)

but Fails on the MAC with a library missing error

What am I doing wrong or how do I get the missing library??

Thanks