Can VBA code automatically operate a website?

I have a website that I use to pull data from including downloading Excel workbooks with the results I need.

The site requires a login as well entering numbers in which it returns values that I use in my Excel workbooks. Can VBA code be written to login, and enter predetermined values from a spreadsheet then download the results which I then use in my workbook?

If not, is there any software available that can operate websites that can be used in conjunction with Excel?

First question : Yes

Second question : Yes

Possibly search for "VBA Automating IE"

You can use a technique called "scraping" where you write to the web page's elements extracted from the web page's source code. You can google "Scraping software".

HTH,
Maud

Originally Posted by Logit

First question : Yes

Second question : Yes

Possibly search for "VBA Automating IE"

Logit, Thank you!

Originally Posted by Maudibe

You can use a technique called "scraping" where you write to the web page's elements extracted from the web page's source code. You can google "Scraping software".

HTH,
Maud

Maudibe, Thank You