LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.outlook.program_vba, microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default "Outlook.Application" vs "Outlook.Application.11"

I have some Excel VBA code which does the following:

Dim objOutlook as Outlook.Application
Set objOutlook = CreateObject("Outlook.Application")

This has been tested and works on Office 2000, 2002/XP, and 2003. However, I
recently encountered problems with the CreateObject line on a client's
workstation, running Office 2003 SP 1. The error I got was 429 -- "ActiveX
Component Can't Create Object". (I got the same error with a
GetObject(, "Outlook.Application") call.)

A Usenet search showed that this might be due to Outlook addins, but I disabled
all of the Outlook addins installed on the machine, and still got this error.

On a whim, I changed "Outlook.Application" to "Outlook.Application.11", and
the code worked fine.

Can anybody explain why this is happening? Is it just a corrupted registry/
Outlook install issue on the client machine, or am I missing something?

I have it working for now, but would like to figure out what exactly went
wrong, in case it happens again.

Thanks in advance for the help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
"WinForm Application" to act as "RTD Server" using .Net mduraidi Excel Discussion (Misc queries) 0 March 30th 06 01:01 PM
Set OutApp = CreateObject("Outlook.Application") - Runtime error 429 Buffyslay Excel Programming 2 July 20th 05 05:06 PM
Why does Outlook.Application.GetNamespace("MAPI") Fail? Lee Excel Programming 4 May 27th 05 02:15 PM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"