Macro for downloading excel and copy pastimg in to diff excel sheet

[Goluojha72]

Hey Team,
I am new in this field
I want a macro code which
1. Open google chrome -new tab -and download the reports by selecting required field
2. Open the downloaded excel file
3. Copy the data from here
4. Paste it in the excel file from where I will run this code
Thanks in Advance

 

[Dan_W]

Hi. That seems like quite a list of tasks you need to automate. What code have you managed to pull together yourself? Any difficulties you need help with? Happy to help you with any problems you've encountered in trying to solve the problem yourself. If you've not come across it yet, you should check out the macro-recorder. Excel will watch what you do and will generate code for you to use in macros. That likely won't work for part of the tasks youve outlined above.

Alternatively, there is also Power Automate Desktop - Microsofts free desktop software that can automate the tasks you've outlined above.

Good luck and let is know if you have some code you'd like some help with.