Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.outlook.program_vba, microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
"WinForm Application" to act as "RTD Server" using .Net | Excel Discussion (Misc queries) | |||
Set OutApp = CreateObject("Outlook.Application") - Runtime error 429 | Excel Programming | |||
Why does Outlook.Application.GetNamespace("MAPI") Fail? | Excel Programming |