Share via

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

Anonymous
2010-10-14T17:43:49+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2010-10-16T14:30:57+00:00

    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

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2010-10-16T11:05:54+00:00

    Am 14.10.2010 19:43, schrieb exr:

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

    I have the same OS and Office version and this code works without any problem on my PC.

    Which registry key are you looking for?

    Andreas.

       Set objExcel = CreateObject("Excel.Application")

      objExcel.Visible = True

      objExcel.Workbooks.Add

      objExcel.ActiveSheet.Cells(1, 1) = "Hello World"

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2010-10-16T15:07:04+00:00

    While not dealing with Excel 2010 specifically, here is a link that describes steps to take for this error message for an earlier version of Excel...

    http://markstechstuff.blogspot.com/2007/07/activex-component-cant-create-object.html

    If the information at that link does not help, here is the Google search link for a series of links about this error message, perhaps one of them might help you out...

    http://www.google.com/search?sourceid=navclient&ie=UTF-8&rlz=1T4ADFA_enUS371US371&q=%22ActiveX+component+can%27t+create+object%3a%27Excel.Application%27%22

    NOTE: Please mark the message or messages (yes, you can mark more than one) that answer your question as the "Answer" so that others will know your question has been resolved.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2010-10-17T19:48:41+00:00

    Excellent Shyam, Thanks for this info.

    Indeed the problem is related to Click-To-Run

    Following the instructions in your first link, I have reinstalled Office 2010 without C-T-R and everything is back to normal.

    In the meantime, I have spend almost 2 hours on the phone to Microsoft Support without getting this SIMPLE answer. I was at the point where MS wanted to charge me $259 to get 'Professional Level Support'!!!

    0 comments