HRESULT: 0x800AC472

Hi everyone,
i have very little experience with programming so please bear with me.

Lately when ever i'm using excel (home and business 2016) i keep getting this Microsoft.NET Framework error

Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.
Exception from HRESULT: 0x800AC472


Does anyone know how i can fix this problem?

thanks in advance.

Do you know about code breaks?

no sorry I don't

Originally Posted by FISHHEAD123

no sorry I don't

Code breaks are when you tell your code when you want to stop and allow for visual step throughs. It is used when you want to see every process that is being taken when you run a code.

To setup a code break go into your visual basic editor and click in the gray bar next to your code. A dark red dot will appear (please see image below). This is a code break. When you run your code, the code will pause when that break is hit. It will allow you to see what is going on as the code continues. Press F8 to advance your code to see what happens next.

You can use this to determine exactly when your error is being triggered and what is causing it.

Attachment 726224

Great thanks frabulator. i'll check this out!

I'm looking for the red dot you mention and i don't see this in the editor. Also the the attachment you sent doesn't seem to open at my side.... Do I need to do something other than click it? Sorry if i'm missing the obvious here?

When you click in the gray bar (where the red dot is) the red dot will appear. You need to click where an action is being made, not something being declared.

Example:

You CANNOT set a break point at:

Dim Bob as String

You CAN set a break point at:

Bob = "Bob Marley"