Auto pull data from a website

[Chad Portman]

Is it possible to make a macro to pull an entire workbook from a website. The
website I wish to pull the data from I need to login to and then click 3
links none of which change the URL to get the workbook that I need to pull.

 

[Bob Bridges]

You want a macro not just to get the data, but to navigate
automatically to the proper place for it, right? I've written
a few VBA programs to navigate the web, and it's
surprisingly complex - not so complex that I didn't think it
worth the effort, but not trivial either. Is the workbook to
be downloaded entire, or is it in scattered data that you
have to read and assemble? If you can walk me through
the process of finding it myself, manually, I can figure out
what it might take to get a VBA to do it automatically.