marcdr Posted November 24, 2005 Share Posted November 24, 2005 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 Link to comment Share on other sites More sharing options...
LxP Posted November 25, 2005 Share Posted November 25, 2005 This is a clumsy workaround but you can maximise the active spreadsheet by sending keys to the Excel window: Send('!-x') Link to comment Share on other sites More sharing options...
marcdr Posted November 25, 2005 Author Share Posted November 25, 2005 Thanks for the help, it works Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now