Couple of Qs

[ihsir]

Using the shell() i call up mediaplayer and play a song given as the argument and use the notepad to read the song lyrics. But these application open up in minimized format instead of their normal/default mode

My Q1 is : How do i open an executible file in the normal mode?


I have total 3 forms and want to create a command button thru which i close all the forms and end the program. But i dont know how to do that (which command/function does that)

My Q2: How do i close up all the open forms and terminate the app?

Also could somebody tell me something about the Terminate and Unload functions.

Any help is appreaciated

PS: I'm a VB noob. Please bear with me if these are stupid and easy questions.

[Buzby]

The Shell command has a parameter to control what the shelled app window state is;

Shell "notepad.exe",vbNormalFocus

will make notepad appear in it's default position with focus.

[Pc_Madness]

Q1

Shell "notepad.exe", vbnormalfocus

Q2
Your app, or the app you've just opened?

Q3
Unload?? as in Unload Form1
Is so, that will close the form. You can use this in a loop to close all forms in your programs.

[alex_read]

Q1) The shell function supports 2 parameters (bit like when you call a program from dos, sometimes you can type extra arguments after it).

VBMINIMIZEDFOCUS
VBNORMALFOCUS
VBMAXIMIZEDFOCUS

Are 3 variables you can place at the end of the shell function (see above posts for sample code), which determine how the shelled application appears on the screen.

[alex_read]

Q2)

Dim frm As Form
 
For Each frm In Forms
    Unload frm
    Set frm = Nothing
Next frm

When a form is loaded into the pc's memory (when the form_load event occurs before the form is shown to the user on the screen), the form object is added to a forms collection.

In basic terms, think of a collection as a table - each cell contains a loaded form. What the above code does is to go through each cell in this table & kill the form. When the above loop finishes, the main form which was shown when you first started up or ran you application was unloaded and it's used reference it was taking up in the computers memory was wiped, so the whole program finishes excecution.

Hope this makes sense!
For more reading on this one, see the MSDN library for "Objects" and why you unload and set them to nothing to clear them.

[alex_read]

Q3) The terminate event fires when the object (form in this instance) has the space it was taking up in the pc's ram removed.

The Unload event occurrs right before the form is removed from the screen so the user can no longer see it. This event occurrs before the above terminate event when you close a form!

[ihsir]

Thanks everybody (esp. alex_read) just the kind of info i was looking for.