Macro to Export report !!

[santhoshbes2729]

Hi Team,

I am in need of your help in guiding me the excel VB macro for the below mentioned requirement inorder to complete my automation project in my organization. Please help me in guiding. Thanks in Advance.

Requirement:

1) Step 1 - Need to open a Web page URL.

2) Step 2 - Web page containing report data (Ex. Open Report generated). Need to export the report by right clicking on it header and select Export --> Excel (.xlsx)

3) Generated report will be saved in Downloads folder.

4) Need to open the downloaded file and copy the data and paste in the template excel sheet starting from Cell A2 in Sheet 1.

Please help me in guiding me the macro to complete my task !!

Thank You !!

Regards,
A.R. Santhosh Kumar