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.
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.