Unanswered

How to select the file under the scroll?

(0) Share

Report

Posted on by alee001

409

I use the selector to capture each file in the loop, but I can't select the file under the scroll in the window, how to solve it? Thanks

螢幕擷取畫面 2023-08-07 092053.png

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

What exactly are you trying to do here? Please don't use the User Interface of the Windows explorer to get a file. There are plenty of actions in Power Automate Desktop that will enable you to do it in a much better way. But in order for us to provide some suggestions, we would need to know what it is exactly you are trying to do.

Was this reply helpful? Yes No
alee001 409 on at

Like
a
(0)

Report
Copy link

Link copied!

Use the PAD to press a VBA button, it will open the file explorer for the user to select a file to input, but the file explorer window needs to be scrolled down to select a file.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you instead type in the filepath into the address field and then send the Enter key? That should work better than scrolling and clicking.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
alee001 409 on at

Like
a
(0)

Report
Copy link

Link copied!

Since the VBA input interface must use the file explorer to select the file, there is no fixed path.

Was this reply helpful? Yes No
alee001 409 on at

Like
a
(0)

Report
Copy link

Link copied!

Maximizing the window can increase the number of selected files, but if there are too many files, the scroll cannot be executed by PAD.

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

Like
a
(0)

Report
Copy link

Link copied!
You can select file by using the '/select' switch in explorer.exe as shown below.

explorer.exe /select, "C:\Test\Text\TestFile_45.txt"

I think you will get a better answer if you provide the specifics of the flow and the VBA code.

Was this reply helpful? Yes No
alee001 409 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for your reference,

The VBA code for the input window of a button in Excel is as follows, and PAD just uses UI elements to capture the input window.
dataDir = Application.GetOpenFilename("Excel file（*.xlsm & *.xlsx & *.xls & *.xla & *.xlt）,*.xlsm;*.xlsx;*.xls;*.xla;*.xlt", , "Select data file", MultiSelect:=False)

Was this reply helpful? Yes No