There is a bug in the split Excel worksheet operation.

(1) Share

Report

Posted on by alee001

331

After trying different methods many times, I found that when the Excel worksheet is split, the PAD process is invalid for the VBA button（copy_fx）. It has no errors but skips the button (process 80). I need to cancel the window split to press the button normally？

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Correct. I don't think split screens work well with Power Automate for Desktop.

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
kinuasa 795 Most Valuable Professional on at

Like (0)

Report
If the action of clicking the VBA button is skipped, I suggest specifying the Macro option in the "Run Excel macro" action as

'(book name)'!(sheet name).(macro name)
Example:
'KK2.xlsm'!Sheet1.copy_fx_Click

to execute the macro directly.

Was this reply helpful? Yes No
alee001 331 on at

Like (0)

Report

kinuasa：

Thank you for your suggestion, but this method is only applicable to Excel files opened through processes. It is not applicable to several independently opened Excel files. It can only be executed by using the UI element recognition button.

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hey there!

I am following up on this post there is a bug in the split excel worksheet operation. in this category power automate desktop from 01/31/2025. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 3 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
alee001 331 on at

Like (0)

Report

The problem has not been solved yet, it may be a problem with different versions. I hope it will be fixed in the next update.

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

I would try whatkinuasa recommended.

Although I think you run the Excel macro by just giving the name of the macro to the action (and the excel instance). Like so:

Since you need to get the excel to be an Excel instance then try these methods:

Method 1
Is the file always KK2.xlsm? If so try using "Attach to running Excel" -action to attach the

Method 2
If the name changes try to get it dynamically into a variable with "Get details of window" and get window title from the Excel window.

In this case there needs to be only one Excel open and you need to change the excel UI selector to not reference any name but just Excel process. This way the Get details of window -action does not try to find an excel window with specific name but just process EXCEL

Method 3
Usually when excel opens it is downloaded temporarily inside C:\Users\YourUser\AppData\Local\Temp\

The path might be: C:\Users\YourUser\AppData\Local\Temp\KK2.xlsm

Close excels with terminate Terminate process -action and use Launch Excel to the path: C:\Users\YourUser\AppData\Local\Temp\KK2.xlsm

Was this reply helpful? Yes No
alee001 331 on at

Like (0)

Report

Since UI elements can only recognize visible buttons, I need to set the cell back to the position where the button is visible, but PAD still cannot execute the buttons of the split window. This may be its defect?

Supplement:
Unless you are the author of the VBA file, others cannot execute the button through macros. They can only execute the button through UI elements.

Was this reply helpful? Yes No