8002801d automation error - library not registered
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.
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
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.