?
Solved

Excel VBA - Exception from HRESULT: 0x800AC472 Microsoft .NET Framework

Posted on 2014-03-19
4
Medium Priority
?
4,452 Views
Last Modified: 2014-04-03
I am working on a project I have worked on many times. The application itself is canned, however it has some inner mapping to data and puts the data on a bookmarks tab. From there in conjunction with this said application, you can print a quote per say.

The canned application has had many revisions and so has the Micro Enabled Template that goes along with it. (I manage the template).

So my issue is when I click on the canned applications Print Quote Button it will load the template and then flash excel on the taskbar. After about 2 minutes the Print quote message box is still up (when it should have closed - canned app) and a Exception from HRESULT: 0x800AC472. Pops up.

Here is a screen shot.

Picture of error when the excel template is opened in the background
I have done a bit of research on this error, but I cannot quite figure out how to use it in my VBA code.

Attached is the details of the error.

This error will allow the end user to continue, but if you want to look back at the application for some reason, you have to hit Quit and then reopen the app. The pop-up message box is staying open and wont die.

HELP??
VBA-messagebox.txt
0
Comment
Question by:Jennifer Barman
  • 2
  • 2
4 Comments
 
LVL 31

Expert Comment

by:gowflow
ID: 39942041
Just as a pure guess do you have the latest Net Framework version installed ? maybe an update ?
gowflow
0
 

Author Comment

by:Jennifer Barman
ID: 39942405
I can make sure, but  I do believe our framework is set at 4.5

Also, I changed some settings and I am now able to see more information on the error.
error-desc.jpg
0
 
LVL 31

Accepted Solution

by:
gowflow earned 1500 total points
ID: 39942820
0
 

Author Closing Comment

by:Jennifer Barman
ID: 39975588
I have about half of it working, still having issues, however I need to create a new article.

Thank you.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question