minimize excel from vb

[mn12]

Hi,
I create reports by excel.my reports are running from vb application (I use VBA and not a control in order to display the report).
when I display the report (like "display before printing&quotand I press on the button that minimize the report,the report only becomes smaller but the vb program stays on normal size.
My question is:How can I minimize the whole application(the excel report AND vb program) together??

 

[RobBroekhuis]

You can minimize the Excel application window using

AppExcel.windowstate=xlMinimized

where AppExcel is your application object, and xlMinimized is an Excel constant (=-4140)

Rob