"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.
|