+ Reply to Thread
Results 1 to 3 of 3

O365 Macro error

  1. #1
    Registered User
    Join Date
    01-15-2019
    Location
    Burton On Trent
    MS-Off Ver
    2010
    Posts
    5

    O365 Macro error

    Hi, I have recently been upgraded to O365 which has corrupted the macros in a document I use on a regular basis

    The macros were originally set up to be able to email individuals directly from excel attaching part of the excel document that contained the information pertinent to them

    When the macros run now it errors very early on with the following;

    Runtime error 429 - activex component can't create object

    I have tried to run the macros on a non O365 machine and it all runs fine

    Can someone help/suggest anything to try?

    I have tried tools > references > and selected the most recent Outlook object library (in this instance 16) but still no joy

    I have attached a demo copy of the document for you to review, the macros is the "automate" "Send Email"

    Any help you can offer would be appreciated

    Thanks

    Richard
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: O365 Macro error

    Here is something on that

    https://www.youtube.com/watch?v=bvBgvew6UA0

  3. #3
    Registered User
    Join Date
    01-15-2019
    Location
    Burton On Trent
    MS-Off Ver
    2010
    Posts
    5

    Re: O365 Macro error

    Thanks, I have tried this previously and my ActiveX Installer is defaulted to automatic

    Do you have any other ideas on how i can resolve this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Win10/O365 Email Macro Slowness
    By ButtonsUK in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-03-2020, 09:19 AM
  2. [SOLVED] O365 - Date not being seen as a number
    By Vlad717 in forum Excel Formulas & Functions
    Replies: 31
    Last Post: 08-14-2019, 04:39 PM
  3. O365 Excel 64 bit problems
    By ks1102 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2019, 11:58 PM
  4. [SOLVED] Slow macro since O365 upgrade
    By bmachefe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2019, 06:12 AM
  5. [SOLVED] xlsm modified on o365 generates compile error
    By HarryKlein in forum Excel General
    Replies: 4
    Last Post: 10-11-2018, 04:17 AM
  6. Replies: 4
    Last Post: 03-02-2018, 10:49 AM
  7. iCloud in O365
    By a2fire2i in forum Office 365
    Replies: 0
    Last Post: 09-12-2013, 02:21 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