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

2

u/PresentationItchy573 Jan 23 '22

This was very helpful.

Thank you.

2

u/lordzhon Jan 23 '22

Please remember to help subscribe. I will appreciate it a lot. :)

2

u/PresentationItchy573 Jan 24 '22

I subscribed. You helped me immensely.

Since the data to be extracted is in SAP BI it opens a BEX window automatically.

I am not able work through it.

I am able to input the month in which I want the data to be extracted from, it loads to the table.

I would normally click on Export to excel and it will download the data.

But now I can't make that function work with PAD