Need Help in Creating Macro to extract data from website.

Hello,
I have to pull data at my work from an external website where there first i need to do is log in then select the report type then run it and it does is out put a Excel data file. This i have to do 120 times since i have to select each different report under different company names. Is there a way where i can create a macro to pull data automatic from the website aftr i log into it. can a VBA macro be created for it?

please advise.

Hi,

start with Automate Internet Explorer …