Outlook Error 429

[Jarvonimbus]

I have been using Outlook VBA on a new PC which was already set-up with Office 2007. Initially, these would would run successfully. I have also used them in the past on Outlook 2000 and 2003.
However, I have subsequently installed Excel2000 to run in parallel with Office2007, as our existing accounts system requires the older version.
Now I am getting an error message "429 ActiveX Component can't create object".
From the following:
Set myOlApp = CreateObject("Outlook.Application")
I have tried googling but not been able to decipher a solution! Please can anyone help? Kind regards

 

[bubba100]

What is your Dim statement for myOlApp? Does this occur in Excel 2000?

 

[Jarvonimbus]

There isn't one - that line given is the first (non-comment) line in the sub. This has worked in both Outlook2000 and Outlook2003
I can say I have tried
Dim myOlApp As New Outlook.Application

But this gives exactly the same outcome

 

[bubba100]

From what application is your code? Excel, Word also please indicate which version. From your code go to Tools>References indicate what is selected.

 

[Jarvonimbus]

It is Outlook VBA - it was originally written in Outlook2000

References selected:
Visual Basic for Applications
Microsoft Outlook 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Object Library

 

[bubba100]

Try using Dim myOlApp as Object, it is called late binding.

 

[PHV]

I have subsequently installed Excel2000 to run in parallel with Office2007
A safer method is to install older product BEFORE newer ...

 

[Jarvonimbus]

Thanks bubba - nope still getting same message

 

[PHV]

As you've installed the applications in the wrong order, you may try to repair the Office 2007 install.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Jarvonimbus]

Thanks PH - yes I think that would be the best way forward