Ask a new question

ActiveX component can't create object:'Excel.Application'

Problem Description: I have several automation projects that I have created and used with Office XP. Now that I have upgraded to Office 2010, none of the automation projects work.

I seems that I no longer have application level objects defined on my system. For instance, the following line in a .vbs file:

Set objExcel = CreateObject("Excel.Application")

gives a script error "ActiveX component can't create object:'Excel.Application'" with error code 800A01AD

When I look in the registry, none of the application entries exist for any of the Office 2010 products.
Operating System: Windows XP 32 bit
Answer
Answer

Have you installed the Click-To-Run version of Office 2010? The C-T-R version cannot be automated by external applications. You should install the full version if that is the case.

 If you have downloaded the Office 2010 Home and Business or the Office 2010 Home and Student version from Office online then they default to C-T-R installs for download but you can choose to download the full version instead.

Office 2010 Click-to-Run compatibility with add-ins-http://support.microsoft.com/kb/982431

Click-To-Run Known Issues - http://office.microsoft.com/en-us/excel-help/click-to-run-known-issues-HA101850565.aspx

Regards, Shyam Pillai. http://skp.mvps.org
Regards
Shyam Pillai

http://skphub.com

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated August 1, 2023 Views 36,860 Applies to: