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!
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.