Minimize Excel Window via code

[Dale Fye]

I am running some automation from Access. I have opened an Excel workbook,
but when I do so, becomes the primary object on screen, rather than my Access
application. I would like to minimize the Excel window once it is open and
visible.

Unfortunately, I'm still not familiar enough with the Excel object model to
figure this out.

Thanks for your assistance.

 

[Dr. Stephan Kassanke]

I am running some automation from Access. I have opened an Excel workbook,
but when I do so, becomes the primary object on screen, rather than my
Access
application. I would like to minimize the Excel window once it is open
and
visible.

Unfortunately, I'm still not familiar enough with the Excel object model
to
figure this out.

Thanks for your assistance.

Hi Dale,

the Excel application object has the windowstate property. I assume you have
an object variable in your Access program, e.g. xlApp which points to your
Excel instance.

xlApp.WindowState=xlMinimized

will minimize the Excel window.

Stephan