How do I minimize

[chrisnsmith]

I know how to open a program in excel. But how do I minimixe it after opening?

 

[JLatham]

Click the little 'minimize' button up in the upper right hand corner of the
window? Actually - you'll find 3 buttons there: from right to left:
X = Close
big square = restore/maximize
underscore looking button = minimize.

 

[chrisnsmith]

I know how to do that.
What I'm looking for is macro to do it automatically.

 

[JLatham]

OK, you said you know how to open a "program" - define program, please: some
other application such as Word, Access, Outlook, etc. or do you mean a
workbook, i.e., another .xls file.

If it's another workbook, then as soon as you open it, it becomes the
ActiveWorkbook and is in the Active window, so you can use
ActiveWindow.WindowState = xlMinimized
right after opening the other workbook.

 

[chrisnsmith]

I should have been more explicit. I'm talking about MicrosoftMail. When I
open it I
would like to minimize it to the system tray and then close it after my mail
has been sent.

 

[JLatham]

I'd probably need to see more of your code on how this is getting done. If
you're opening MicrosoftMail (a tool I don't use except to read usegroups)
within Excel, then somewhere you've got a reference to the instance of it and
should be able to use .Minimize and .Quit within your code to handle that,
although determining when it has finished sending your mail may be a bit
problematic.

 

[chrisnsmith]

This is what I use to open MicrosoftMail.

Sub openmail()
Application.ActivateMicrosoftApp xlMicrosoftMail
End Sub

I would like another macro to minimize the app on opening and close it after
the mail is sent.

 

[Bill Sharpe]

This is what I use to open MicrosoftMail.

Sub openmail()
Application.ActivateMicrosoftApp xlMicrosoftMail
End Sub

I would like another macro to minimize the app on opening and close it after
the mail is sent.

Why bother with a macro? Use keyboard shortcuts.
Alt-Spacebar-N will minimize the app.
Alt-F4 will close the app.

Bill

 

[JLatham]

That's the way I'd go with it since he's just used Excel to open Microsoft
Mail and hasn't actually used it to create an object that he can control any
further within Excel.