I have a file name, ex: "8shvytsj.xlsx". I'm using the UI "Click UI in Window" in many places to set values. Is is possible to universally change "8shvytsj.xlsx" to "MyFile.xlsx" all the "Click UI in Window" events?
Solved! Go to Solution.
If you are trying to replace text inside the code of PAD, PAD does not have a Replace function for it's own code. Example, we recently upgraded a server name from XXXXXX01 to XXXXXX02 and I couldn't just replace all everywhere in the code when referring to filenames or addresses on the server.
However, if you are trying to get all your Excel "Click UI elements" to work in a different workbook, follow below:
Open the UI pane in the top right.
Find your Excel UIs...Note how mine are "bok cost test v2.xlsx"
Hover your mouse over the window row so the 3 dots appear, click them and click Edit selectors
Again, hover the mouse to display the 3 dots, click the 3 dots and click Edit selectors again
Here, if you simply uncheck "Name", then the Excel UI elements you have will work on ALL Excel documents; you just have to make sure the one you want is in focus. If you specifically just want it to work for "MyExcel.xlsx", then change the name to match.
Best of luck!
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!