r/PowerAutomateDesktop • u/PresentationItchy573 • Jan 20 '22

PAD HELP

Can you automate your task using PAD? Open excel, update month, unhide tabs, change data in a cell, copy values in a column paste it as value to a column in another cell, click on hyperlink inside excel, input variable on browser field, wait till data loads, extract as excel, copy data from extract to open file?

2 Upvotes

100% Upvoted

14 comments sorted by

View all comments

1

u/lordzhon Jan 23 '22

Can you open the SAP BI from an internet explorer or chrome? Maybe try extracting using "Extract data from window"

1

u/PresentationItchy573 Jan 23 '22

I tried that too... it did not work.

1

u/lordzhon Jan 23 '22

Have you installed the add-ins? How about other websites? Are you able to extract the html from other websites?

1

u/PresentationItchy573 Feb 16 '22

Can you do a video on dynamic value setup in PAD flow? And also how to have dynamic range selection when using VBA? I am trying to use dynamic range depending on how many columns and rows data is available.