Unanswered

Navigating Excel by Keyboard Issue

(0) Share

Report

Posted on by lightarchon

Hello,

Since the newer update of Power Automate Desktop.
I am unable to navigate Excel using keyboard shortcuts.
It was using a combination of Alt+A+E to set "Text to Columns"

When I manually press the keys on the excel window, it has no issues. Prior to the most recent release, Power Automate Desktop was able to perform this task without issue. It now seems to make a "bling" sound as tho it could not perform the action.

I am unsure why. I have tried different combinations of not/sending Hardware Keys, attempting to use the the "Press Key" and "Release Key", to even trying to find direct keyboard shortcut to the desired formatting window, and see it work with key combiniations Ctrl+Shift+F working as intended.

I was planning on expanding it to format multiple data types to the appriopiate data for the column that is being used.

Any help would be highly appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

The Sendkeys should be associated with a focus on the window prior to calling it.

Either use

i. Focus Window (to focus on the Excel file window)

ii. Sendkeys (Select Foreground window)

OR

i. Attach to running Excel (will give %ExcelInstance%)

ii. Sendkeys (select Window Instance/handle and pass %ExcelInstance%)

Use {Alt}({A}{(E)}) for Sendkeys

I have tried both the options and both are focusing on the Excel window and giving the below screen.

Was this reply helpful? Yes No
lightarchon 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I will try that today and get back to you.

Was this reply helpful? Yes No