I've been able to use the scheduler to start a worksheet and automatically
run a macro (thanks to Tom Ogilvy), however I still can't get the
spreadsheet and Excel to close and quit. What am I missing?

Thanks again

Hi buckle

ThisWorkbook.Close False ' save and close the file

ThisWorkbook.Close True ' close the file without saving

Application.Quit ' close Excel


--

Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl

"buckle" wrote in message news:3f414bb9$1@nubby2....
I've been able to use the scheduler to start a worksheet and automatically
run a macro (thanks to Tom Ogilvy), however I still can't get the
spreadsheet and Excel to close and quit. What am I missing?

Thanks again

Thanks Ron,

I inserted:

ThisWorkbook.Close False
Application.Quit

- in the macro and the workbook closes, but Excel stays open? Do I need
something more?

Thanks again

"Ron de Bruin" wrote in message
...
Hi buckle

ThisWorkbook.Close False ' save and close the file

ThisWorkbook.Close True ' close the file without saving

Application.Quit ' close Excel


--

Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl

"buckle" wrote in message news:3f414bb9$1@nubby2....
I've been able to use the scheduler to start a worksheet and
automatically
run a macro (thanks to Tom Ogilvy), however I still can't get the
spreadsheet and Excel to close and quit. What am I missing?

Thanks again

*shrug* Who knows?
Have you tried :
Application.Quit?

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"buckle" wrote in message news:3f414bb9$1@nubby2....
I've been able to use the scheduler to start a worksheet and automatically
run a macro (thanks to Tom Ogilvy), however I still can't get the
spreadsheet and Excel to close and quit. What am I missing?

Thanks again