MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How can I close an active excel window from command line?


Posted by Piero on December 27, 2001 6:33 AM

I've scheduled a macro, so it starts automatically from command line (with the AutoOpen() command--thanks to Rick E!) ; but then I need to close it, from command line yet.What command should I try?
Thanks for any help!
Bye


Posted by Scott on December 27, 2001 6:41 AM

I'm not sure if I follow. You want to run a macro when you close the workbook? If so, you could use:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
'\Your Macro\

End Sub

You would have to do this under workbook and not under modules.

Posted by piero on December 27, 2001 7:24 AM

I'm sorry I have not managed to explain may problem properly.
This is what I need to know : the macro I've made opens a new worksheet, and then automatically closes itself, leaving only this new worksheet(which don't contains any macro).
What should I do to close this new worksheet?
I think that I must use a dos command...
Thanks!


Posted by Joe Was on December 27, 2001 7:37 AM

If you set up some pre-program or splash page to run on startup but did not build Exit code into your startup macro code, you can generally stop a running macro with the "Esc" Escape key. If this is the case I would suggest you add a control button or exit code to your startup macro, to avoid this situation.

If the escape key works and stops your macro you can code a button with:
Application.SendKeys("{ESC}")

If escape did not work post your code and we will figure out an exit code. JSW