Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 22nd 21, 07:30 PM posted to microsoft.public.excel.programming
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




  #2   Report Post  
Old February 23rd 21, 11:42 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2016
Posts: 19
Default Activex component cannot create object Excel 365 for mac

On 22/02/2021 18:30, lamar spalding wrote:
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.


According to a post on stackexchange

https://apple.stackexchange.com/ques...ok-2016-on-mac


"both Outlook and OneNote do not support VBA on the Mac (although Excel,
PowerPoint and Word do)".

A Workaround mentioned is Applescript.

--
Adrian C
  #3   Report Post  
Old February 24th 21, 05:15 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2019
Posts: 86
Default Activex component cannot create object Excel 365 for mac

"lamar spalding" wrote in message
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
====================================

Outlook can't be automated in 365 for Mac, start here with Ron de Bruin's
'Excel for Mac' site -

https://www.macexcel.com/examples/mailpdf/macoutlook/

Peter T




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activex component can't create object Naveen New Users to Excel 1 September 4th 07 02:57 PM
Error 429 ActiveX Component can't create object Mike Hartsough Excel Programming 2 September 26th 06 03:00 PM
error 429: ActiveX component can't create object GerryM Excel Programming 0 October 13th 04 05:53 PM
ActiveX Component Can't create object - Any Explainations? gopalan Excel Programming 0 January 5th 04 04:25 PM
activex component can't create object with SAP 6.20 Mark Bigelow Excel Programming 0 July 22nd 03 06:24 PM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017