Selecting multiple worksheets

[SalmanAhmed]

Hi All If any one help here.   How can I select multiple worksheets?   Example: I need to select more then one work worksheet and need to send Ctrl + p Keystroke.   How can I achieve this scenario in Blueprism   PFA     Thanks Salman Ahmed

[BenKirimlidis]

Hi Salman, If i understand you: You want to to interact with multiple sheets at the same time i.e. pasting some values / text. There isn't a way to do it simultaneously but you can absolutely do it in series, one after another. You can open multiple workbooks using the same handle, and then address each opened workbook by name.  Using different handles can creates some annoyances so try and stay inside of a single Handle for a single piece of work. In order to paste into multiple worksheets on one or more workbooks.I suggest creating a collection of handles,workbooks,worksheets and starting cell locations, then looping through them. That should have the desired outcome.  Unless there is something else that I'm missing from your request? Kind regards, Ben

[AmiBarrett]

Try automating it like you would any other application, either via Win32, UIA or Accessibility. If you know the tab names and/or positions, you should be able to send Ctrl+click to the element.

[AmiBarrett]

Clarification and amendment to that: You'll need to send a Ctrl Down event using Global Send Key Events, then use Global Mouseclick Center on the tab, then use another Global Send Key Events with a Ctrl Up.