Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: killing Excel 2002 silently?


    I have a batch file that queries a database and creates a flat file.
    I want to start Excel, make a graph of the data and save it as an html file. I then want to get out of Excel.

    I want to do this automatically twice daily (eg at midnight).

    I use Scheduled tasks and a macro to start Excel and create the graph. But Excel won't quit so I've set the ask Scheduler to stop Excel after 1 minute.

    Here's the problem ... I get a message saying that Excel has terminated unexpectedly and would I like to send an Error Report to Microsoft?!

    I cannot turn this message off no matter what Service I stop!

    Does anyone have any ideas how I might accomplish my aim?

    thanks very much

  2. #2
    Join Date
    Dec 2003
    San Diego, CA
    Have you tried Application.Quit?


    EDIT: Welcome to the Board!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts