Microsoft Office Forums - View Single Post - Opening Excel from Word gets "Automation Error

sts023 · 09-28-2019, 09:14 AM

I'm working in Office 2010, using Excel 2010 and Word 2010.

when I try to open an Excel 2010 spreadsheet in Word 2010. I get the message "Automation Error - Library not registered". This code is part of an on-going project which used to work fine (until my old Windows 7 PC blew up).

Having tried to research this I think I may know what the problem is, but I'm not sufficiently skilled to work out the solution.

I think it's because when I bought my new PC it had a trial version of Office 365 installed. As I already have a fully licensed version of Office 2010 which I am quite happy with, I uninstalled Office 365 before the "end of trial approaching" nag screens started.

I have the following references checked
Visual Basic For Applications
Microsoft Word 14.0 Object Library
OLE Automation
Normal
Microsoft Office 14.0 Object Library
Microsoft Excel 14.0 Object Library

My simplified code follows

Code:

Option Explicit
Public Sub GetDataFromExcel()
Dim appExcel                As Excel.Application
'*
'** Create a new Excel application.
'*
  Set appExcel = New Excel.Application
End Sub

Also failing:-

Code:

Public Sub GetDataFromExcel()
Dim appExcel                As Excel.Application
'*
'** Create a new Excel application.
'*
'  Set appExcel = New Excel.Application
  Set appExcel = CreateObject("Excel.Application")
End Sub

From what I can gather from some posts on various help desk sites, my PC is getting confused because of a Registry entry which may have been left behind by an imperfect uninstall of Office 365. The suggested solution(s) suggest editing the Registry to remove references to parts of Office 365.

I get very nervous using regedit - I subscribe to the old adage "a little knowledge is a dangerous thing".

Can anyone explain in very simple language what to look for to confirm the diagnosis, and how to get around it?

As Office 365 was pre-installed on my new PC (from Aldi), I don't have any installation CDs to uninstall or repair it, so I can't "start over again".

I really need to get my Word project working soon, and without being able to get it to talk to Excel I'd need a major redesign and re-code.

Can any kind soul offer any help?

Thanks in advance....