ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Extracting Data from the Web (https://www.excelbanter.com/excel-programming/380481-extracting-data-web.html)

Dan R.

Extracting Data from the Web
 
Is there a way to extract/screen scrape data [into an excel
spreadsheet] from a website that requires a login? I'm trying to cut
down on all the manual work my team does every day and this seems to be
the most logical way to do it.

If so, can you please provide some syntax that could get me started? Or
perhaps even an online resource or a book on the subject you think
might be helpful. I'm somewhat new to programming so I'd prefer
anything in VB...

Thanks a lot!
- Dan


John Bundy

Extracting Data from the Web
 
you can see if it will let you intercept the url once you are logged in, then
use that, or do a search for automate IE for discussions/code on iserting
data into an IE form.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Dan R." wrote:

Is there a way to extract/screen scrape data [into an excel
spreadsheet] from a website that requires a login? I'm trying to cut
down on all the manual work my team does every day and this seems to be
the most logical way to do it.

If so, can you please provide some syntax that could get me started? Or
perhaps even an online resource or a book on the subject you think
might be helpful. I'm somewhat new to programming so I'd prefer
anything in VB...

Thanks a lot!
- Dan



[email protected][_2_]

Extracting Data from the Web
 
You can easily develop the extracting solution using
SWExplorerAutomation (http://webiussoft.com)


Dan R. wrote:
Is there a way to extract/screen scrape data [into an excel
spreadsheet] from a website that requires a login? I'm trying to cut
down on all the manual work my team does every day and this seems to be
the most logical way to do it.

If so, can you please provide some syntax that could get me started? Or
perhaps even an online resource or a book on the subject you think
might be helpful. I'm somewhat new to programming so I'd prefer
anything in VB...

Thanks a lot!
- Dan




All times are GMT +1. The time now is 10:36 AM.

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