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

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?

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?

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?

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?

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

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?