Closeing an Excel Spread sheet

[dornan]

Hi I have a macro that auto closes a spread sheet with the: -

Workbooks("name.csv").close

Command to close it, I then have a batch file that starts the same spreadsheet again a few minutes later.

A couple of times now the spreadsheet hasn’t closed properly and although it doesn't appear on the screen the excel.exe process in task manager is still running. Is there a better way to shut excel down through a macro so it is more reliable?

Thanks

 

[Andrew Poulsom]

You could try:

Application.Quit