Changing file for UI Elements

[rickvvaldez]

Hello all,

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?

Thank you

Rick

[MichaelAnnis]

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!

[rickvvaldez]

Great answer, thank you for your help!

[VJR · Accepted solution]

Hi @rickvvaldez, Looks like you have found an answer to your question from @MichaelAnnis' post. Is it good enough to mark the post as solution and close the thread? Feel free if you have more questions on the same topic as of the original thread was opened.