Marc,

I ran the macro recorder and got this (with a little tweak to change from
Activewindow to the window for Book1). It minimizes Book1 but Book 1 is
still the active workbook.

Sub Macro1()
Windows("Book1").WindowState = xlMinimized
End Sub

hth,

Doug

"Marc Nations" wrote in message
...
So it forces you to have an active workbook. I didn't know that. I guess
you can always default to the first workbook in the list.

But is there any way to simply minimize the workbook? I think that would
be the easiest thing to do.

And I can't close it because then it severs my connection to the COM
server. If there's a way to reconnect to the workbook after it's closed,
I'm not aware of it.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!