Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 11th, 2016, 01:56 PM
Registered User
 
Join Date: Jan 2015
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
Default Runtime Error 429 - ActiveX Component cannot create Object

I have VBA code/macro in Excel that opens Outlook and emails a temporary saved copy of this Excel spreadsheet to a distribution list.
When I manually start the spreadsheet, it run without issue - generating emails via Outlook.
When I use MS Windows Task Scheduler to auto-start the same spreadsheet, I get the above error message trying to setup Outlook message,
Set OutApp = CreateObject("Outlook.Application")





Similar Threads
Thread Thread Starter Forum Replies Last Post
ActiveX Component can't create an object lihar Access VBA 1 December 20th, 2006 07:52 AM
Run time error 429- ActiveX component can't create carswelljr VB How-To 2 September 8th, 2006 12:22 PM
Run time error 429 - ActiveX component can't creat carswelljr Pro Visual Basic 2005 2 September 8th, 2006 11:32 AM
ActiveX component can't create object lameneural Classic ASP Components 0 July 4th, 2006 12:14 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.