VB Syntax, Executing code on exit.

Executing code on exit.

Author	Message
Fred Holm #1 / 3	Executing code on exit. VBA6 Is there a way to use some "handle" such that when a user clicks on the close/exit box in the upper right corner of the main form of a VB6 program, some VBA code (a subroutine) can be called to execute before the program exits? What is the handle called? I want to be sure that no matter how a user decides to quit, some spawned instances of Excel are closed before the VB6 program exits. The problem generally occurs when a user decides to quit the program before he has finished making a "run," i.e., he just wants to dump what he is doing right now and free up the resources -- or even shut down. If the spawned instances of Excel aren't killed when the program is exited, they delay the shut down of the Operating System, as one gets an error message that "Excel.exe is not responding!" I know how to write the code to kill Excel; I just don't know how to call it in the instance when the user clicks the close box. Thanks, Fred Holmes
Sat, 07 Jun 2003 04:09:06 GMT

Randy Birc #2 / 3	Executing code on exit. Use the UnloadMode value of the QueryUnload event -- its value will indicate a system (control) menu close if the X or sysmenu Close option is selected -- see the help file for exact values passed. -- Randy Birch MVP Visual Basic Take the vb.net poll at: http://www.mvps.org/vbnet/ http://www.mvps.org/ccrp/ : VBA6 : : Is there a way to use some "handle" such that when a user clicks on : the close/exit box in the upper right corner of the main form of a VB6 : program, some VBA code (a subroutine) can be called to execute before : the program exits? What is the handle called? : : I want to be sure that no matter how a user decides to quit, some : spawned instances of Excel are closed before the VB6 program exits. : : The problem generally occurs when a user decides to quit the program : before he has finished making a "run," i.e., he just wants to dump : what he is doing right now and free up the resources -- or even shut : down. If the spawned instances of Excel aren't killed when the : program is exited, they delay the shut down of the Operating System, : as one gets an error message that "Excel.exe is not responding!" : : I know how to write the code to kill Excel; I just don't know how to : call it in the instance when the user clicks the close box. : : Thanks, : : Fred Holmes
Sat, 07 Jun 2003 04:17:33 GMT

orit #3 / 3	Executing code on exit. you can check the msdn for the order of the events which are called when the app is "over"... you have the formunload and the queryunload... usually the best place to locate yr code before terminating the application is in the queryunload event.. orit Quote: > VBA6 > Is there a way to use some "handle" such that when a user clicks on > the close/exit box in the upper right corner of the main form of a VB6 > program, some VBA code (a subroutine) can be called to execute before > the program exits? What is the handle called? > I want to be sure that no matter how a user decides to quit, some > spawned instances of Excel are closed before the VB6 program exits. > The problem generally occurs when a user decides to quit the program > before he has finished making a "run," i.e., he just wants to dump > what he is doing right now and free up the resources -- or even shut > down. If the spawned instances of Excel aren't killed when the > program is exited, they delay the shut down of the Operating System, > as one gets an error message that "Excel.exe is not responding!" > I know how to write the code to kill Excel; I just don't know how to > call it in the instance when the user clicks the close box. > Thanks, > Fred Holmes
Sat, 07 Jun 2003 05:16:17 GMT

Page 1 of 1

[ 3 post ]