ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto pull data from a website (https://www.excelbanter.com/excel-programming/424844-auto-pull-data-website.html)

Chad Portman

Auto pull data from a website
 
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[_2_]

Auto pull data from a website
 
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.

--- "Chad Portman" wrote:
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.



All times are GMT +1. The time now is 07:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com