Maximise Excel Sheets

[marcdr 0]

Hi All,

Is there a way to maximise the spreadsheets in excel. I can maximise the main Excel window but not any spreadsheets that are not maximised when excel opens.

I have this at the top of my script:

opt("WinTitleMatchMode", 2)

opt("WinSearchChildren", 1)

and I tried this in the script:

WinSetState("Microsoft Excel", "Worksheet in Basis (1)", @SW_MAXIMIZE)

"Worksheet in Basis" is the spreadsheet I want to maximise.

Hope I have explained it well enough. Thanks in advance for any pointers

Marc

[LxP 1]

This is a clumsy workaround but you can maximise the active spreadsheet by sending keys to the Excel window:

Send('!-x')

[marcdr 0]

Thanks for the help, it works