Unexplained "Automation error Exception occurred" from Excel

Question

I'm getting "Automation error Exception occurred" (+ crash) from Excel 2016 for all macros for all workbooks. Started happening some time in the last week (same code worked fine last week)

I created a test case, empty workbook with a single module.

---

Option Explicit

Option Base 1

Public Sub DoIt()

MsgBox "Done" 

End Sub

---

If I run it with F5 from inside the VBA editor, it works fine.

If I run it from Developer > Macros > DoIt, error + crash.

I tried doing a "repair" of my office installation, no change.

Thoughts?

Answer 1

Here's the solution (since my problem hadn't gone away).

• Open the VBA editor (Alt + F11)
• Tools > References
• check-mark "AccessibilityCplAdmin 1.0 Type Library"
• SAVE
• (close and reopen Excel)

I learned this in Stack Overflow and it worked like a charm.

Answer 2

What is working for me is to call another sub that does the work.

In your example would work like this:

Public Sub DoIt()

MsgBox "Done"

End Sub

Public sub message()

call Dolt

end sub

Answer 3

I get the same result - I still get the error if I try to call "message" fro Developer > Macros. But works fine if I F5 from the VBA window.

Answer 4

Hi, I just started my PC and it went back to normal. Shut down and turn on...that did it for me. :-)

Answer 5

Unfortunately didn't help for me...