Thread: Getting Run Time error 429: ActiveX Control can't create object
View Single Post
 
Old 08-03-2021, 09:25 PM
sampritiagarwal sampritiagarwal is offline Mac OS X Office 2016 for Mac
Novice
  
Join Date: Aug 2021
Posts: 1
sampritiagarwal is on a distinguished road
Exclamation Getting Run Time error 429: ActiveX Control can't create object
The excel automation was created in Windows and is not running in MacOS. Also, it seems ActiveX Control is not supported by MacOS. Can someone help me write a code where it is showing me a debug.

The automation was made to send a bunch of automated email from HCL Notes (Mailing tool) via this excel VBA.

Let me know if someone can help


Code where it is showing error:

Set notesSession = CreateObject("Notes.NotesSession")
Set notesDatabase = notesSession.GETDATABASE("", "")
If notesDatabase.IsOpen = False Then notesDatabase.OPENMAIL
Reply With Quote