Discussion Locked

Closing Excel from command line

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a question on EXCEL 2000. I do a post backup command from my backup program(GRbackPro) to open an Excel file which runs a macro to append data and closes the file again. However , I cannot get Excel to close down. How can I do this , either from the macro or on the command line in the GRbackPro program. Thanks.

3 replies

by dklippert

The answer was to place Application.Quit following ActiveWorkbook.Save.
The Application.Quit will close the workbook as well.
Glad you got it working, Good luck.

This discussion is closed to new replies.