A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

CreateObject(), GetObject() question



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old February 20th 10, 02:05 AM posted to microsoft.public.outlook.program_vba
Salad
external usenet poster
 
Posts: 24
Default CreateObject(), GetObject() question

I have the following sub
Sub test()
'it doesn't matter which of these I use.
Dim olApp As Object
'Dim olApp As Outlook.Application

'always a (8007007e) error with following line.
'Set olApp = CreateObject("Outlook.Application")

'never get an error as long as Outlook is open
Set olApp = GetObject(, "Outlook.Application")
Set olApp = Nothing
MsgBox "Done"
End Sub

I have a reference set to Microsoft Outlook Object Library.

I commented out the CreateObject() line because I get a runtime error
(8007007e) "Automation Error: The specified model could not be found."

It works with the GetObject() line...but only if Outlook is open. If
Outlook is closed, I get an runtime error 429 "ActiveX can't create
object. Is this normal?

Any idea of what is wrong?
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
GetObject - Outlook/Excel 2007 JoeRob Outlook and VBA 14 January 22nd 10 12:36 AM
CreateObject Fails with Error 429 [email protected] Outlook and VBA 3 January 22nd 09 10:23 AM
Legacy applicaton with CreateObject not working in Outllook 2007 Howard Myers Outlook - General Queries 1 June 27th 08 08:01 AM
Error 429 CreateObject Alberto[_2_] Outlook and VBA 7 May 12th 08 05:29 PM
OLK2007 : The Oper Failed : Application.CreateObject("MAPI.Session Bill Billmire Outlook - Using Forms 3 January 7th 07 01:02 AM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright 2004-2025 Outlook Banter.
The comments are property of their posters.