<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Selecting multiple worksheets in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Selecting-multiple-worksheets/m-p/82140#M33615</link>
    <description>Hi All

If any one help here.

&amp;nbsp;

How can I select multiple worksheets?

&amp;nbsp;

Example: I need to select more then one work&amp;nbsp;worksheet and need to send Ctrl + p Keystroke.

&amp;nbsp;

How can I achieve this scenario in Blueprism

&amp;nbsp;

PFA

&amp;nbsp;

&amp;nbsp;

Thanks

Salman Ahmed</description>
    <pubDate>Tue, 26 Feb 2019 00:06:00 GMT</pubDate>
    <dc:creator>SalmanAhmed</dc:creator>
    <dc:date>2019-02-26T00:06:00Z</dc:date>
    <item>
      <title>Selecting multiple worksheets</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Selecting-multiple-worksheets/m-p/82140#M33615</link>
      <description>Hi All

If any one help here.

&amp;nbsp;

How can I select multiple worksheets?

&amp;nbsp;

Example: I need to select more then one work&amp;nbsp;worksheet and need to send Ctrl + p Keystroke.

&amp;nbsp;

How can I achieve this scenario in Blueprism

&amp;nbsp;

PFA

&amp;nbsp;

&amp;nbsp;

Thanks

Salman Ahmed</description>
      <pubDate>Tue, 26 Feb 2019 00:06:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Selecting-multiple-worksheets/m-p/82140#M33615</guid>
      <dc:creator>SalmanAhmed</dc:creator>
      <dc:date>2019-02-26T00:06:00Z</dc:date>
    </item>
    <item>
      <title>Hi Salman,
If i understandâ€¦</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Selecting-multiple-worksheets/m-p/82141#M33616</link>
      <description>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.Â&amp;nbsp; 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.Â&amp;nbsp; Unless there is something else that I'm missing from your request?
Kind regards,
Ben</description>
      <pubDate>Sun, 12 May 2019 18:10:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Selecting-multiple-worksheets/m-p/82141#M33616</guid>
      <dc:creator>BenKirimlidis</dc:creator>
      <dc:date>2019-05-12T18:10:00Z</dc:date>
    </item>
    <item>
      <title>Try automating it like youâ€¦</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Selecting-multiple-worksheets/m-p/82142#M33617</link>
      <description>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.</description>
      <pubDate>Mon, 13 May 2019 19:51:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Selecting-multiple-worksheets/m-p/82142#M33617</guid>
      <dc:creator>AmiBarrett</dc:creator>
      <dc:date>2019-05-13T19:51:00Z</dc:date>
    </item>
    <item>
      <title>Clarification and amendmentâ€¦</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Selecting-multiple-worksheets/m-p/82143#M33618</link>
      <description>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.</description>
      <pubDate>Mon, 13 May 2019 19:55:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Selecting-multiple-worksheets/m-p/82143#M33618</guid>
      <dc:creator>AmiBarrett</dc:creator>
      <dc:date>2019-05-13T19:55:00Z</dc:date>
    </item>
  </channel>
</rss>

