Excel 2003 + script to open and automatically close an excel workb
 

Hi, i have a scheldule to run at a certain time, the excel sheet will open,
run a macro and automatically close. The trouble i'm having is the workbook
keeps staying open and not fully closing. Is they a better way to do this?

Help would be greatly appreciated.

Neil.

Excel 2003 + script to open and automatically close an excel workb
 

"Not fully closing" means what?

Is it "partially closing"?

What remains after the partial close?

Do you want Excel to close also?

Application.Quit will close Excel.

Post your code.


Gord Dibben MS Excel MVP

On Thu, 4 Mar 2010 02:46:01 -0800, Neil Holden
wrote:

Hi, i have a scheldule to run at a certain time, the excel sheet will open,
run a macro and automatically close. The trouble i'm having is the workbook
keeps staying open and not fully closing. Is they a better way to do this?

Help would be greatly appreciated.

Neil.