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" wrote:

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" wrote:

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

"JLatham" wrote:

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

"chrisnsmith" wrote:

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