Global sendkeys for SPACE BAR
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-03-16 02:40 PM
hi,
I am trying to perform filter operation in excell ,as a part of it I need to send (SPACE BAR ) as a keystoke.
any help will be appreciated ,
Thanks In advance.
7 REPLIES 7
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-03-16 03:01 PM
Hi Prasad,
The quick answer is to use the 'Global Send Keys' rather than 'Send Keys Events' using an input of ""{SPACE}"" however, there may be a better way of applying filters if you can give me a bit more information around your intentions for the data and what format it is currently in.
Many Thanks,
James
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-03-16 03:22 PM
Hi James,
I tried using ""{SPACE}"" but this will not work for both 'Global Send Keys' and 'Send key Event'.
I just want to filter data in excel where I want to select some data, so trying to achieve this using Space bar to check the checkboxes there.
Thanks
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-03-16 04:40 PM
You should activate it before sending the key .
/Kiarash
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-03-16 04:59 PM
Hi Prasad,
Out of interest are you sending these keys via the MS Excel VBO provided by BP or have you created something of your own to interact with Excel?
Thanks,
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-03-16 07:12 PM
Hi James,
I haven't created any, but using surface automation we can work with Excel by interacting with the menu items there.
but here we cannot access the rows and columns actually,but selecting would be possible using send keys.
Thanks
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-03-16 07:43 PM
The Space Bar as a keystroke is simply "" "" because it is just a text character like any other keybaord letter, rather than a control key.
If you are trying to use the Space Bar as some kind of control key (i.e. to press a button) it probably will not be possible - because when using Send Keys or Send Key Events you are sending characters to the entire appliction rather than individual elements (which is why the element needs to be active first).
The best way to press a button is by sending a global click rather than a space.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-16 04:53 PM
Hello Everyone,
Please use space in quotes "" "". Hope it will work.
Regards,
Atul
