Skip to main content
Question

Simulate keystrokes not working in excel unattended mode


It's working in dev attended bot but not in unattended mode.​ scenario is giving ctrl f3 to open name manager window to create a table for selected range. It's not working in unattended mode

14 replies

  • Author
  • Cadet | Tier 2
  • 2 replies
  • June 28, 2022

Hi @Tamil Arasu​ 

 

i used simulate keystrokes with "Ctrl down f3 ctrl up" and 10ms delay

then if Name manager window exists, Recorder-Capture to set text table name and click close save and so on


Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+15
  • Most Valuable Pathfinder
  • 3271 replies
  • June 28, 2022

Hi @Lathamangeshkar Naviri​ ,

 

Did you tried to capture steps using AI Sense Recorder to do this ( open name manager window to create a table for selected range)


Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+15
  • Most Valuable Pathfinder
  • 3271 replies
  • June 28, 2022

So, It's working !


  • Author
  • Cadet | Tier 2
  • 2 replies
  • June 28, 2022

Nope this is the actual line of code I used in my bot. In unattended mode, that keystroke is not performing in excel and bot is checking name manager window. It is not found, so no table is created and next step vlookup has #N/a val​. That is the issue


Forum|alt.badge.img+11

Zaibi
Forum|alt.badge.img+6
  • Navigator | Tier 3
  • 128 replies
  • December 12, 2022

Dear @Latha N,

 

Regarding your query, keystrokes work regardless of the nature of deployment, but you have to understand that they only work on the element it is supposed to, if that element is put into focus.

You could try using Window: Activate Action to bring the window to the foreground, but ideally you ought to use Object Cloning/Capture Action as it its much more reliable than keystrokes.
Is anything preventing you from using the former? If so please elaborate so that we can help you out.

 

Regards,


Padmakumar
Forum|alt.badge.img+13
  • Navigator | Tier 3
  • 785 replies
  • December 13, 2022

Hi @Latha N ,

 

Simulate Keystroke execution speed is faster when compared to the normal Set Text action within the Recorder-Capture action. Which will be a problem for some unattended BOT execution occasions.

As a workaround, you can try increasing the time delay for each keystroke to tackle with this issue for the time being. I had this issue before and the same is working as expected after this small change.


Forum|alt.badge.img+4
  • Navigator | Tier 3
  • 11 replies
  • December 13, 2022

Hello everyone,

I am facing exactly the same issue. I am using drag key actions in excel to drag the formulas across cells with the cell range of more than 2000.

I have to use only the simulate keystroke action for the performance. Now its not working in unattended bot.

Please assist me on this. 


Padmakumar
Forum|alt.badge.img+13
  • Navigator | Tier 3
  • 785 replies
  • December 13, 2022
Madhu24 wrote:

Hello everyone,

I am facing exactly the same issue. I am using drag key actions in excel to drag the formulas across cells with the cell range of more than 2000.

I have to use only the simulate keystroke action for the performance. Now its not working in unattended bot.

Please assist me on this. 

Hi @Madhu24 ,

 

Please try the method which I mentioned above. It actually helped me in my case.


Forum|alt.badge.img+4
  • Navigator | Tier 3
  • 11 replies
  • December 13, 2022

Hi @Padmakumar 

I tried the method you suggested, i gave like 5000 ms and its still not working.

Padmakumar wrote:
Madhu24 wrote:

Hello everyone,

I am facing exactly the same issue. I am using drag key actions in excel to drag the formulas across cells with the cell range of more than 2000.

I have to use only the simulate keystroke action for the performance. Now its not working in unattended bot.

Please assist me on this. 

Hi @Madhu24 ,

 

Please try the method which I mentioned above. It actually helped me in my case.

 


Padmakumar
Forum|alt.badge.img+13
  • Navigator | Tier 3
  • 785 replies
  • December 13, 2022
Madhu24 wrote:

Hi @Padmakumar 

I tried the method you suggested, i gave like 5000 ms and its still not working.

Padmakumar wrote:
Madhu24 wrote:

Hello everyone,

I am facing exactly the same issue. I am using drag key actions in excel to drag the formulas across cells with the cell range of more than 2000.

I have to use only the simulate keystroke action for the performance. Now its not working in unattended bot.

Please assist me on this. 

Hi @Madhu24 ,

 

Please try the method which I mentioned above. It actually helped me in my case.

 

Just add a Capture Window action before and after this Keystroke action and see what the behavior of the execution there.


Forum|alt.badge.img+4
  • Navigator | Tier 3
  • 11 replies
  • December 14, 2022
Padmakumar wrote:
Madhu24 wrote:

Hi @Padmakumar 

I tried the method you suggested, i gave like 5000 ms and its still not working.

Padmakumar wrote:
Madhu24 wrote:

Hello everyone,

I am facing exactly the same issue. I am using drag key actions in excel to drag the formulas across cells with the cell range of more than 2000.

I have to use only the simulate keystroke action for the performance. Now its not working in unattended bot.

Please assist me on this. 

Hi @Madhu24 ,

 

Please try the method which I mentioned above. It actually helped me in my case.

 

Just add a Capture Window action before and after this Keystroke action and see what the behavior of the execution there.

 

Hi @Padmakumar I am getting black screen in both capture window and capture desktop


Padmakumar
Forum|alt.badge.img+13
  • Navigator | Tier 3
  • 785 replies
  • December 14, 2022
Madhu24 wrote:
Padmakumar wrote:
Madhu24 wrote:

Hi @Padmakumar 

I tried the method you suggested, i gave like 5000 ms and its still not working.

Padmakumar wrote:
Madhu24 wrote:

Hello everyone,

I am facing exactly the same issue. I am using drag key actions in excel to drag the formulas across cells with the cell range of more than 2000.

I have to use only the simulate keystroke action for the performance. Now its not working in unattended bot.

Please assist me on this. 

Hi @Madhu24 ,

 

Please try the method which I mentioned above. It actually helped me in my case.

 

Just add a Capture Window action before and after this Keystroke action and see what the behavior of the execution there.

 

Hi @Padmakumar I am getting black screen in both capture window and capture desktop

 

Which means the last logout from the RDP machine was not proper or someone else might be having an active session during the BOT execution. 

Try using the enclosed .bat file or perform the sign-out action through Run window and try if you can tackle this situation.

 


Forum|alt.badge.img+4
  • Navigator | Tier 3
  • 11 replies
  • December 14, 2022
Padmakumar wrote:
Madhu24 wrote:
Padmakumar wrote:
Madhu24 wrote:

Hi @Padmakumar 

I tried the method you suggested, i gave like 5000 ms and its still not working.

Padmakumar wrote:
Madhu24 wrote:

Hello everyone,

I am facing exactly the same issue. I am using drag key actions in excel to drag the formulas across cells with the cell range of more than 2000.

I have to use only the simulate keystroke action for the performance. Now its not working in unattended bot.

Please assist me on this. 

Hi @Madhu24 ,

 

Please try the method which I mentioned above. It actually helped me in my case.

 

Just add a Capture Window action before and after this Keystroke action and see what the behavior of the execution there.

 

Hi @Padmakumar I am getting black screen in both capture window and capture desktop

 

Which means the last logout from the RDP machine was not proper or someone else might be having an active session during the BOT execution. 

Try using the enclosed .bat file or perform the sign-out action through Run window and try if you can tackle this situation.

 

Thanks for assisting me. Its working


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings