Excel Macros -- how do I exit Excel from a macro?

  • Thread starter Thread starter NJBrit
  • Start date Start date
N

NJBrit

I need to edit a spreadsheet created each day at 5.45 am. I have
scheduled task running at 5.55am, that opens another workbookwhich ha
a macro that runs on open. This macro reformats and saves the workboo
I need, and then closes it and exits. Now I'm left with Excel in memor
with no open sheets. No problem if I'm in work that day, but if I'
out for a week, a new instance of Excel is added each day!
Is there a VBA/macro command that can shut down Excel completely?

THANK

And
 
Hi-- appreciate the quick response, this didn't work -- at first.
Then I realized that statement had to come *before* the
ActiveWorkbook.Close !!

THANKS again.
And
 
I wonder what would happen if you tossed the "activeworkbook.close" line
completely?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: Help creating a macro that will run Solver? 3
Run Macro Automatically When Excel 2003 Opens 2
Import 4 Different Excel Files from One Folder 0
Excel TWO Instances of Excel One watching Other 3
2003 Macro in Excel 2007 1
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
Time dependant Excel Macro 1
Excel Macro Warning problems 1

Back
Top