Simulate keystroke in AA 360 fail for excel shortcuts

  • 11 November 2023
  • 0 replies


Hi, I have this Excel automation task where I have to apply filter checks on almost all the columns and then check values. Additionally, I have to work intensively with the Excel menu/option bar. Let's say in my case I am applying a filter to the entire header row (Row 1 of Excel) and after that, I get a filter dropdown on each column I open it with AA simulate Keystrokes activity (ALT+ Down Arrow), once filter drop-down appear I simulate (F) which highlight filter text option then I simulate (enter) to select equals to option. after that, I get “custom autofilter” I simulate (enter) on that to set a blank filter to the column. so total keystrokes become (ALT + arrow down + f + enter). I am facing an issue that sometimes it works sometimes it does not. I have tried changing the time between the keystrokes option (10-400)miliseconds. The thing is it's not consistent. How to overcome this challenge? I tried using the universal recorder but not consistent as well. I even tried to make the Excel window active before simulating keystroke activity but still no progress. The last option is to run macros and apply a filter via VBA, but I want to utilize keystrokes. 


0 replies

Be the first to reply!