"automation error" "unspecified error"

  • Thread starter Thread starter ML Purdy
  • Start date Start date
M

ML Purdy

When opening Excel, I get multiple instances of this error in a Microsoft
Visual Basic error box. It also happens when I open an existing spreadsheet
and when I edit the worksheet.

There is no error number.

Everything seems to work fine, it is just annoying as heck.

I have tried a repair, and a repair/reinstall. Neither has worked.

I have not uninstalled Office and reinstalled it.

Can anyone help?

Thanks in advance.
 
Try removing any addins that you have. Also remove personal.xls from the
xlStart folder. Both of those can have code that would run when you open XL
and or a spreadsheet. If that solves your problem then we just need to narrow
down which one is causing the problem...
 
Thank you Dave/Jim and Purdy for sharing this in the forum. I also came
across the same error and this post was very helpful. I started excel in safe
mode and completed detect and repair. This seems to have resolved the problem!

Thanks once again. :)
 
Back
Top