"Automation Error...Unspecified Error".

Whenever I open Excel or Word, I get 2 errors....1 telling me to close a dialog box...and 2 a Microsoft Visual Basic pop up saying "Automation Error...Unspecified Error". This just started yesterday. What can I do to fix it?
 

Question Info


Last updated October 16, 2018 Views 30,737 Applies to:

Is your compute connected to a network or domain?

Provide the complete error message you receive.

 

Method: 1

You may try to start your Word and Excel application in safe mode and check if it works fine

Click Start, Run type ‘WinWord /safe’ (For Word)

‘Excel /safe’ without quotes in search program and files and hit enter (For Excel)

Note: there is a space between ‘WinWord’ and /

Note: there is a space between ‘Excel’ and /

If Word and Excel works fine as expected you may disable add-ins in Word/Excel by following the steps below:

You may refer to the link below to know how to disable add-in Excel 2007:  

http://office.microsoft.com/en-us/word-help/enable-or-disable-add-ins-in-office-programs-HA010034127.aspx

 

Method: 2

Browse to the locations and remove the files from the startup folder and check if it works fine:

C:\Program Files, Microsoft Office, Office14, XLSTART

C:\Users,User Name, AppData, Roaming, Microsoft, Excel, XLSTART

Note: Take a backup of startup folder before deleting the files.

C:\ Program Files, Microsoft Office, Office14, Startup, (Word)

Note: Take a backup of startup folder before deleting the files.

 

Method: 3

Repair Office 2007 using the article below:

http://support.microsoft.com/kb/924611

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.

Thanks Raju,

In our case it was one of our vendor add-ins that was in the XLstart directory in method 2. It must not be compatible with a recent security patch. I installed several over the weekend and this came up on Monday.

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.

Thanks a lot Raj, One irritating factor of my problem got resolved :-)

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.

Thanks Raju,

 

My one year problem is resolved now.

 

 

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 tried all these -

Method 1 - the error still happens in safe mode

Method 2 - Searched the folders, none of those locatons had any files to remove.

Method 3 - ran diagnostics, no errors found.

 

The file containing the macro is from a well known and large Tech industry company. The macro allows selection of data to be presented in excel, likely from some hidden connection or source (I cannot see the raw data sheet being queried).

 

In the Excel Trust Center, I have enabled all macros and activeX, and enabled external content. Still this Visual Basic error occurs and I cannot run the macro. 

 

This error occurs in both excel 2003 and 2007.

 

Hope you can point me to the next possible thing to try.....

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