8002801d automation error - library not registered

Hi Guys,

I hope you can help me on this one. 

On my work laptop I am running Windows 7 64 bit, Office 2003. 

I mistakenly installed the Office 2013 preview (I wanted to just download it) and then as it had installed on my work laptop, I uninstalled it. 

Since doing that, I now cannot open Excel through VBA, I am getting an Automation Error: 8008201d - Library Not Registered when I run the following command:

Set objExcel = CreateObject("Excel.Application")

I have searched online about this extensively, and found one solution to the problem to re-register the .dll files. 

This is where I am having a problem however, I have tried re-registering several files, but the some will not register, I get another error saying it has loaded but failed to call on DllRegisterServer with Error Code 0x80004005. I am an administrator and have tried running cmd with administrator rights, to no avail. 

I then also updated to a copy of Office 2007 that I had, but having the exact same issue. 

Please help me in any way you can, it is crucial that I get this working and I would be grateful to anyone who can assist. 

Kind regards,

Sam Cackett
 
Question Info

Last updated August 13, 2018 Views 20,661 Applies to:

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

You may try the following:

Step 1. Go to Run Prompt and Type “regedit” and click ok Step 2. Expand HKEY_LOCAL_MACHINE Step 3. Expand Classes Step 4. Expand TypLib Step 5. Expand 00020813-0000-0000-C000-000000000046 Step 6. Select 1.8 Step 7. Right Click on 1.8 and Delete this.

147 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

thank you!!! after searching the web for hours ... this solved my problem, too!!

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Great decision. It helped me too!

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Solved my issues as well. Thank you very much!

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Many thanks josmongeorge - this did the trick for me.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Many Thanks josmongeorge, for the answer ........

for me i faced the same error while switching from Access 2007 to Access 2010 .....

I checked the same path in Regedit and instead of 1.8 i found 1.7 and by deleting it my issue is resolved.....

hope that would be helpful for some as well...

DanS

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Hi ,

  As per above instruction I have deleted "00020813-0000-0000-C000-000000000046" from registry. But still it is not working. It gives me the same Run Time Error. 

Please help to solve the issue. 

BR 

Saikat

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

I was getting that exact error message and this solution helped fix my issue!

Thanks

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Years later... Still helpful!  Thank you. Solved my problem, too.  :)
Dan

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

It works!! Thank you so much! :)

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.