 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / COM / December 2004VB & Excel Automation
We have a VB application which formats raw data (.tsv files) and generates Excel Reports. The application runs 24X7 and formats around 1000-2000 reports every day. It has 3 instances running all the time to take care of the report generation. We clear all the errors that the Formatter throws for every two hours and ensure smooth report generation. The Problem: The Excel hangs some times causing the report generation for that particular instance get struck indefinitely. Since hung instances donot have any return codes and since they are not any kind of errors, we are finding it difficult to identify whether a particular Excel instance is hung or not. Can anyone tell us how to programatically detect that a Excel Instance hung? > We have a VB application which formats raw data (.tsv files) and generates > Excel Reports. The application runs 24X7 and formats around 1000-2000 reports [quoted text clipped - 10 lines] > > Can anyone tell us how to programatically detect that a Excel Instance hung? Off the top of my head, why not set a timer, if no return code before the timer fires, you've got a problem. A long shot, maybe it will work. Dave Anil, I think that there are following options: 1. Find exact reason as in why the application hung? Is there some problem with coding or whet? I have used excel many times for generating reports and my experience tells me that there is always some thing we can do to improve our code. 2. Since we can estimate a successful completion time we can also probe that a particular application is hung or not. > > [quoted text clipped - 60 lines] > >  SignatureBest, _____________ Bharat Sharma * TEN Technologies. * Official Web: _www.ten-technologies.com_ <http://www.ten-technologies.comemail/> Personal Web: _www.bharatsharma.net_ <http://www.bharatsharma.net/> |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.