Need to MAXIMIZE EXCEL OPENED AS AN INSTANCE

Hi All ,

Please see below my process .

Using MS Excel VBO I Opened a Excel instance.

I Opened a WB

I later Show it Using the Show Action . Now it appears in my Task Bar... I want to maximize it or activate it for sending keys.

>>>>Now I want that excel opened to be maximized on the Screen.... So that I can send some Global Keys to perform some actions....

View attachment 1537887751859.png

Please do let me know your valuable inputs . I tried with Worksheet Activate WB Activate etc but I could not achieve the desired.

BR
Shabaz.
 

VJR

Well-Known Member
Staff member
Hi SyedShabaz03,

At first you need to Attach the Blue Prism Object to the Excel file using the Window Title (using wild cards based on the file name) and the Process Name ("excel") parameters in the Navigate stage (Attach action).

View attachment 1537273381015.png

Once the object is attached, spy the outside border portion of the Excel window.
Using this element will give a 'Maximise' action in the Navigate stage.


View attachment 1537273196285.png

Ideally speaking the Excel should not be spied especially when there is a ready-made Ms Excel VBO by Blue Prism.
Down the line things may get complicated if several things need to be spied in Excel.
 
Hi SyedShabaz03,

At first you need to Attach the Blue Prism Object to the Excel file using the Window Title (using wild cards based on the file name) and the Process Name ("excel") parameters in the Navigate stage (Attach action).

View attachment 1990

Once the object is attached, spy the outside border portion of the Excel window.
Using this element will give a 'Maximise' action in the Navigate stage.


View attachment 1989

Ideally speaking the Excel should not be spied especially when there is a ready-made Ms Excel VBO by Blue Prism.
Down the line things may get complicated if several things need to be spied in Excel.

Thanks VJR!

As said and according to your suggestion...
The element which has the maximize option works...but BP has to identify that element first to maximize.when the element (border of Excel )is not showing up on the screen then how will it identify. It's failing says no elemts found.

I tried the same.
I have Excel opened using the VBO. I am able to see the opened Excel in taskbar with show action of MS Excel VBO.

Now I want to maximize. This.

As advised by you I have tried it allready but it is not working.

I have the application modeler where the root parent element I have defined is excel.exe.

For this root I used a attach stage using the wild card entry.
For eg my file name is sepfile.
I attached it as sep* and it's attaching .

So now as advised I have spyed the border of sepfile when the file opened on the desktop.i used the maximize restore and tried other actions too....
The problem.is BluePrism.is able to attach to sepfile....but when it is about to do the maximize action....it has to identify the child element i.e the border of sepfile file that I have added as an child element .it has the action macimize but before performing the action it has to identify...and when the Excel is just shown in the task bar....it attached but for maximizing it is failing ...since it could see any Excel on the desktop opened to match the spyed border element .....so it returns me no elemnts.matched error
..
Hope you understand my explanation
Do write me if needed more .

Thanks
Shabaz
 
Last edited:

VJR

Well-Known Member
Staff member
Hi Shabaz,

I was able to attach to an Excel file and Maximise it using the suggested approach.
So, no, I am unable to understand your issue.
-Do you not have the Excel open on your machine when the process is running? You have used ShowWB, so it should be visible.
- Also you have mentioned excel.exe whereas I have suggested only "excel" as the process name.
-What attributes have you ticked in the Modeller for the border element?
-During spying when you click on Highlight, does it get highlighted?

Do answer for each of the queries to get a better idea of the issue.
 

Deva393

Member
Hi SyedShabaz03,

At first you need to Attach the Blue Prism Object to the Excel file using the Window Title (using wild cards based on the file name) and the Process Name ("excel") parameters in the Navigate stage (Attach action).

View attachment 1990

Once the object is attached, spy the outside border portion of the Excel window.
Using this element will give a 'Maximise' action in the Navigate stage.


View attachment 1989

Ideally speaking the Excel should not be spied especially when there is a ready-made Ms Excel VBO by Blue Prism.
Down the line things may get complicated if several things need to be spied in Excel.



Hi VJR

How to maximize the main frame window
 
Hi VJR

How to maximize the main frame window
Hi Deva393,
As said byVJR earlier in he thread, it is very, very unlikely that you really need to spy Excel.

This will be far more problematic in the long run, and you should consider using the Object Model to make use of Excel functionality.
What is it that you are trying to do?
 

Deva393

Member
Hi Deva393,
As said byVJR earlier in he thread, it is very, very unlikely that you really need to spy Excel.

This will be far more problematic in the long run, and you should consider using the Object Model to make use of Excel functionality.
What is it that you are trying to do?


Hi Anton Hosang,
Thanks for your reply,

I am unable to maximizing the mainframe application after launching. Help on it.
 
Top