Maximize the Excel Screen

[AsitabhaDeb]

Hi Experts,

Can you please help me how to Maximize Excel screen using code, I don't know if any BO is available or not.
Please help me ASAP.

------------------------------
Asitabha Deb
------------------------------

[NicholasZejdlik]

You can create a new page on the Excel VBO. Passing an input of Handle, here's the code:

Dim Excel = GetInstance(Handle)
Excel.WindowState = -4137 ' xlMaximized​

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

[AsitabhaDeb]

Hi.

Why I am getting error " End of Statement Expected" after enter the code.
I have declared "handle input parameter.



------------------------------
Asitabha Deb
------------------------------

[david.l.morris]

Make sure you're entering those as two separate lines of code. There should be a line return after the close parenthesis.

------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------

[AsitabhaDeb]

Hi,

Why I am getting below error message.
Attachment for ref.


------------------------------
Asitabha Deb
------------------------------

[AndreyKudinov]

Because it is Excel.WindowState, not Excel.WindowsState

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------