Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2007

Tip: Looking for answers? Try searching our database.

Extracting Data from the Web

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dan R. - 03 Jan 2007 23:35 GMT
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 - 04 Jan 2007 00:11 GMT
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.
Signature

-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.

> 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
[quoted text clipped - 8 lines]
> Thanks a lot!
> -  Dan
alex_f_il@hotmail.com - 10 Jan 2007 19:15 GMT
You can easily develop the extracting solution using
SWExplorerAutomation (http://webiussoft.com)

> 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
[quoted text clipped - 8 lines]
> Thanks a lot!
> -  Dan
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.