I have two problems.
First,I have an excel file. Each sheet in the file has one or more pivot tables. I need to refresh each pivot table, but I don’t know the name of each pivot table. Is there any good way to let me know Is the name of each pivot table in each sheet or let me refresh all the pivot tables directly? You need to know this name to use’Refresh Pivot Table’ activity.
Another question is, when the current robot is in a state of waiting for a transaction, I want to display a more beautiful pop-up window on the screen to indicate the current state. Can the’Create Form’ activity add a background image (dynamic image)? , What should I do if I can, or any better suggestions or solutions for this situation?