When using your computer and you try to automate Microsoft Office applications with Visual Basic macros, you may receive the following error message:
“Run-time error ’429′: ActiveX component can’t create object”
This happens when the Windows ‘COM’ cannot create the requested Automation object, and the Automation object is therefore unavailable to Visual Basic. However this error does not appear on all computers.
The Microsoft Office applications are automated using an automated server system, this is generally based on the Windows COM architecture. The COM, or Component Object Model architecture, is a binary-interface standard for software componentry.
