How to maximise excel workbook?

[chk]

Hi all,

How can I maximise the excel workbook in UiPath studiox before continuing with actions?

My downloaded excel workbooks are so minimised that the actions cannot be performed.

Looking forward to replies.

Thank you!

[Gokul001 (Gokul Balaji)]

Hi @chk

You can use UiPath’s “Attach Window” activity to select the selector of the Excel file that you have opened and then use the “Maximize Window” activity inside the “Attach Window” activity

Check out this thread

Focus window on excel file and maximize

Hello everyone, I am having trouble getting my bot to focus on the excel file which is opened by the excel application scope, straight after the excel file is opened is a hotkey activity meant for the excel file to get rid of filters but instead it is carried out on UiPath instead and this causes the bot to stop due to not detecting the data required. I have tried looking at similar threads and am not familiar with dynamic window attachments or selectors, I am looking for a solution that bring…

You can also use UiPath’s “Get Active Window” activity to bring the window front

Check out the thread

How to maximize the excel file that i open?

Hey guys, im kinda pissed off at why it is not opening the excel when i already put win+up combination to maximize the excel and i have tried other methods to open but still cant. As you can see the excel is hiding, which i dont want i want it to open > [image]

Regards
Gokul

[arjunshenoy]

Hi @chk

On opening excel, execute the following macro to maximise the excel window:

Sub MaximizeExcelWindow()
    
    Application.WindowState = xlMaximized
    
End Sub

Hope this helps,
Best Regards.

[Anil_G (Anil Gorthi)]

@chk

May I know what actions you want to perform?

Generally for excels we have dedicated activities…please check

https://docs.uipath.com/activities/other/latest/user-guide/about-the-excel-activities-pack

cheers

[chk]

Hi all, I just realised there is a an option to resize window to be maximise under properties. Will try it and let all know.

[chk]

Hi @arjunshenoy, how to run the macro on a new downloaded workbook? Or does the macro needs to exist already in a a workbook / excel file?

Thanks

[arjunshenoy]

@chk

1. Store this macro in a textfile & keep the text file in your project folder (preferably).
2. Use an activity ‘Invoke VBA’.
3. For the activity, give in code file path of this text file & set the entry method name as ‘ MaximizeExcelWindow’

By this way, you can use the same macro for n number of times in your process.
Note: In order for this activity to work, Trust Access to the VBA project object model must be enabled from Excel (File > Options > Trust Center > Trust Center Settings > Macro Settings > Select the Trust Access to the VBA project object model check box).

Hope this helps,
Best Regards.

[chk]

Thanks will try this out in future!

[chk]

This option works perfectly. Thanks all for the discussion!