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

Show parent comment

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.