How to get Excel window to foreground to send key strokes?

Help Activities
, , , , , ,
1

Hello experts!
I am using send keys activity to save excel file from SAP.
I need to do RDP to access SAP and download excel file.
When I open RDP screen and use send keys activity to save excel file it works perfectly But real problem arises when I close the RDP screen, send key activity is not working .

What’s may be the problem ?

2

Hi @Prabin_Chand,

Are you downloading files from RDP to your machine?
of course, send key won’t work if RDP screen is closed.
What actions are causing to close the RDP screen?

3

Hi @Prabin_Chand
Send hotkey does not work on the background; it needs the window and should be visible. In order to change the process to the foreground, use click activity to save a file.

4

Hi @Prabin_Chand, are you using the SAP in RDP,
If yes means you want to keep RPA screen open to download the SAP file.

5

No,
All the files are downloaded in RDP server.
My machine is just for doing RDP

6

Opening RDP screen or closing it doen’t matters.
My aim is to save the excel file in RDP server using send keys.

7

I did used attach window , get active window activities but all fails to work.

8

Hi @Aakash_Singh_Rawat ,
The screen used to be closed by default.
Current I am developing my automation in developer server using RDP.
And I need to publish it to production sever in future which is a virtual Server . which is screen closed by default as we cannot see virtual server until and unless we do RDP.

When i do RDP and see Screen is open send keys works fine, but when i close the RDP server it is not working!

9

Hi @Prabin_Chand , Try this steps

  1. Make sure that shortcut keys are working manually or not
  2. Don’t indicate anything in Send Hotkey and try again

Have you installed the UiPathRemoteRuntime in RDP server ?

10

Hi @rohin_Kumar ,
I have already tried step 1 and it’s working perfectly

Not sure if i have installed UiPathRemoteRuntime

11

Hi @Prabin_Chand, Try to indicate some desktop shortcuts logo, if it is indicate means no problem or else you need to install it to automate the RDP server

12

Hi @rohin_Kumar ,
yes, it is indicating the logos in desktop as i have already installed UiPath in my developer server

13

Fine, Finally try this
1.click on the SAP screen before using send hotkey
2.Don’t indicate anything in Send Hotkey and try again

14

Hi @rohin_Kumar ,
Send keys is perfectly working fine.
when when i close the rdp send key is not working.

15

Error is showing!

WhatsApp Image 2023-01-24 at 12.30.36 PM
WhatsApp Image 2023-01-24 at 12.30.36 PM1036×492 37.1 KB

16

You are using the SAP in RDP sever, You want to download the excel file in RDP server using send hotkey, so why are you closing RDP, If you closing the rdp means send hotkey will not work at background

18

Which system are you using Attended or Unattended
Attended means u have one more step to do

19

Thanks everyone for your time to reply.
I am much familiar with vbscript so i code in vbs to save excel file which solved my problem

20

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.