Jump to content

Recommended Posts

Posted

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

Posted

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

Send('!-x')

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...