Dear all,
following problem i´m facing:
- Several Excel Files with same structure (but different filenames) are connected with SAP Analysis for Excel to a database
- Up to now, i´m updating the files manually which takes a long time for me
- Now i want to let PAD to the work for me 🙂
My approach was following:
1) Set variable for the Folder Path
2) Get files in folder
3) Implemented the "for each" action to grab every file after each other
4) The run application i used, because sometimes it happened, that the addin "SAP analysis for excel" was not loaded
5) The wait function is implemented, because depending on the file size, it took longer to get the file loaded.
6) From the process step "Select tab in windows" i used the Recorder in PAD.
I assume, that something is running wrong because of the usage of the recorder function, because in the UI element section i see, that PAD stored the name of the first file.
When the flow is running and coming to the 2nd file (which have a different filename) it runs to an error.
I´m not sure, if this is really the root cause, but it looks like, because i changed now the file name and got immediately the same error message within the 1st file.
How could i store the UI-element in a way, that it is independent from the file name? Or is my assumption wrong?
