Macro for downloading files from website into excel

[AlexPeteson]

Hi Community Members

Is it possible to do a excel vba to automate the following? Initially, I was intending to record a mouse & keyboard movement macro, please advise

Step1: Open a website URL and login using credentials (Username and Password) daily
Step2: Navigate the website via a few mouse clicks and ultimately click "Generate Report" button
Step 3: Open downloaded excel file and copy the information (Containing data in multiple rows and columns) in the another main excel workbook called X (Pasting right below the historical data like a compilation)

Thanks for the assistance!

Regards
Peteson

 

[jbesclapez]

Hi,
If the URL is not fixed than I think you are screwed.
You can try to record your mouse and keyboard using Mouse Tamer... but this is far from an excel solution
Good luck