Export Excel and save as specific file name on a particular drive

I understand there are questions regarding export to excel but I couldn’t find definitive answer.
After loading a part webpage I get a table where I have the option of exporting to excel.

When I click on this element, I get IE message which says
Do you want to open or save ExcelExport234513.xlsx from xyz.com which includes option of Open, Save, Saveas, save open and cancel

I want this file export to be saved on a particular drive location so that my excel macros can read and format.

Is there a option to do this efficiently in UiPath?

If you are able to get the excel download url from Website itself, use below

If not, you need to click Save As - > Type Into → New Path

To click on Save as —> Indicate on Screen → F2 (gives you 3 seconds to click on arrow) —> Indicate Save AS

1 Like

To click on Save as —> Indicate on Screen → F2 (gives you 3 seconds to click on arrow) —> Indicate Save AS

I didnt get 3 seconds option. I dragged Indicate on screen to the environment and clicked F2. What am i doing wrong ?

Click Activity ->Indicate on Screen → Click F2 (you will see below 3 second timer on bottom right) → It allows you to click on drop down arrow → Indicate on Save As

1 Like