View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default 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