Small yet annoying
 

Hi

I've created a macro in excel which runs overnight via a batch file in
MS autoschedule. At the end of the program I've used
"Application.Quit" which should shut Excel down and then the .bat file.

It doesn't work and the file remains open - any ideas why not?

Any alternatives?

Thanks in advance

R

Small yet annoying
 

Just make sure that
Application.Quit
is preceeded by
Application.DisplayAlerts=False
--
Gary's Student


" wrote:

Hi

I've created a macro in excel which runs overnight via a batch file in
MS autoschedule. At the end of the program I've used
"Application.Quit" which should shut Excel down and then the .bat file.

It doesn't work and the file remains open - any ideas why not?

Any alternatives?

Thanks in advance

R