Excel giving "System Error &H80004005 (-2147467259). Unspecified error" message

vba excel activex system-error
icebird76 picture icebird76 · May 29, 2015 · Viewed 14.6k times · Source

Everytime I load up my Excel document, it repeatedly shows up with the message from the title. The two options are OK and Help. help opens Office Help which is useless for anything. Clicking OK displays another message saying "Compile error: Out of memory." with OK and Help buttons. Clicking OK brings up VBEditor with no debug line selected and no macro popped up either for that matter. Eventually, after it repeats that and complains 20 (exaggeration) more times (I think that's due to having a lot of duplicate code for ActiveX controls on each sheet). It highlights the first line (the Sub declaration) of the code below.

Private Sub ComboBox4_Change()
Range("B3") = ActiveSheet.ComboBox4.text
End Sub

Now this is dealing with an ActiveX ComboBox. Opening a file from an earlier date will give no errors. It's like after a certain date, it just refuses to work with it. And get this, it's only happening on one computer. The files are saved on a network drive, which shouldn't be causing an error.

Answer

icebird76 picture icebird76 · Nov 25, 2015

I believe the problem was that I had a user form with an acrobat reader display control (like an iframe, but for PDFs). I didn't have this reference or control on that specific computer and it freaked out. Not 100% sure, but the problem no longer exists.

Related questions

Microsoft Excel ActiveX Controls Disabled?

I have some Excel worksheets that use ActiveX checkboxes to control certain activity. They worked recently but today started to give errors. I was alerted to this by a colleague, but it was still working on my computer. I checked …

Read More
What is the difference between "Form Controls" and "ActiveX Control" in Excel 2010?

Using Microsoft Excel 2010, I noticed two kind of controls that can be inserted into a document: Form Controls and ActiveX Controls. What is the difference between them?

Read More
Creating Word Application using Excel VBA: Run-time error '429': ActiveX component can't create object

I am trying to save Word docs using Excel VBA, but I get the error "ActiveX component can't create object." When I debug, the error comes from the line: Set wrdApps = CreateObject("Word.Application"). It was working, then it started …

Read More