Results 1 to 5 of 5

Run-time-error '429': ActiveX component can't create object --> Create Email w/ Excel info

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2020
    Location
    Fort Lauderdale, FL
    MS-Off Ver
    Office 365
    Posts
    2

    Run-time-error '429': ActiveX component can't create object --> Create Email w/ Excel info

    Hello everyone.
    I am getting an error when running the Macro below on a Mac.
    Debugger highlights section Set OutApp = CreateObject("Outlook.Application")
    Would appreciate some guidance as to what should be done for this Macro to work on a Mac. Thank you.

    Complete macro code follows:


    Sub CXR()
    
    ActiveSheet.Unprotect Password:=""
    
    ' Don't forget to copy the function RangetoHTML in the module.
    ' Working in Office 2000-2010
        Dim rng As Range
        Dim OutApp As Object
        Dim OutMail As Object
     
        With Application
            .EnableEvents = False
            .ScreenUpdating = False
        End With
     
        Set rng = Nothing
        On Error Resume Next
        Set rng = ActiveSheet.Range("CXR_Range").SpecialCells(xlCellTypeVisible)
        On Error GoTo 0
     
        If rng Is Nothing Then
            MsgBox "The selection is not a range or the sheet is protected" & _
                   vbNewLine & "please correct and try again.", vbOKOnly
            Exit Sub
        End If
     
        Set OutApp = CreateObject("Outlook.Application")
        Set OutMail = OutApp.CreateItem(0)
     
        On Error Resume Next
        With OutMail
            .To = ActiveSheet.Range("B9").Value
            .Cc = ActiveSheet.Range("B10").Value
            .BCC = ""
            .Subject = ActiveSheet.Range("B11").Value
            .HTMLBody = RangetoHTML(rng)
            .Display   'or use .Send
        End With
        On Error GoTo 0
     
        With Application
            .EnableEvents = True
            .ScreenUpdating = True
        End With
     
        Set OutMail = Nothing
        Set OutApp = Nothing
    
    ActiveSheet.Protect Password:=""
    
    End Sub
    Last edited by davesexcel; 10-01-2020 at 04:20 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. For the Mac Run-time error 429 ActiveX component can't create object
    By Jsalisbury in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2021, 04:56 AM
  2. Run-time Error '429': ActiveX Component Can't Create Object
    By Ganesh7299 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-17-2015, 04:04 PM
  3. VBA Excel : Run time error '429': ActiveX component can't create object
    By devendravitm in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-20-2013, 02:07 PM
  4. Run-time error '429' ActiveX component can't create object
    By gamaz in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-29-2012, 10:24 PM
  5. [SOLVED] Run-time-error '429': ActiveX component can't create object
    By Lloyd Blankfein in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-28-2012, 07:21 PM
  6. Run Time error 429 (ActiveX component can't create object)
    By vijanand1279 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2012, 03:08 PM
  7. Run-time error ‘429’ ActiveX component can’t create object
    By AliJay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-14-2012, 05:13 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1