p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_codeclinic thread: Desperate Try


Message #1 by "Tan, Eng" <Eng_Tan@t...> on Mon, 12 Mar 2001 09:48:46 -0500
Actually, excel files are already created with formulas and macros already 
in them. However, some user input are also fed into the excel files to be 
used with the formulas.

> Hi there,
> 
> Are u creating excel files on user input or acc. to
> records from a database...
> 
> 
> 
> --- "Tan, Eng" <Eng_Tan@t...> wrote: > 
> > > I have posted this and have not received any
> > feedback. I am starting to
> > > wonder either...this cannot be done, or no one has
> > come across my problem.
> > > Please take the time out to respond even to tell
> > me "I am glad that I
> > > don't have this problem."
> > > 
> > > I just need to know from ASP page, how do I quit
> > an excel file that is
> > > hanging on the server once there is an error in
> > excel caused by due to
> > > some unknown reason. 
> > > 
> > > My previous message (below) is enclosed for better
> > description of my
> > > problem.
> > > 
> > >
> >
> -------------------------------------------------------------------------
-
> > > -----------------------------------------
> > > 
> > > Subject: Is there a way to timeout the EXCEL
> > Application from the ASP
> > > page? For Example, if I wanted ASP page to quit
> > and close the EXCEL
> > > Application that is currently running when the
> > browser has waited for 3
> > > minutes? 
> > > 
> > > The need for this is, we have our users creating
> > the Excel that invloves
> > > macros, fomula and such. The users are
> > specifically given a set of
> > > standard rules on the NAMES of the worksheets and
> > NAMES of the files to be
> > > used. In my ASP pages, I am able to trap these
> > obvious errors by checking
> > > if these WORKSHEET NAMES and FILE NAMES exist. If
> > not, I quit and close
> > > the excel object. This has been working great
> > until we come across a
> > > SPECIAL scenario. 
> > > 
> > > Let say their creation of macros in these files
> > were not so perfect and
> > > caused the excel to croak. What happens on my ASP
> > page then is, it hangs
> > > and hangs. What is also happening is that the
> > EXCEL application on our
> > > server is still running. When this happens many
> > times to many users, there
> > > are all these loose EXCEL application running
> > forever. (We had 12 Excel
> > > Applications hanging at one point!!!)
> > > 
> > > Thanks in advance.
> > > Eng
> > > 
> > > 
> > > 
> > 
> > 

  Return to Index