Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing from site?

Status
Not open for further replies.

diezzz

Technical User
Oct 11, 2006
28
HU
I don't know if it can be done, on BSD wget <adress> -o file.html grep "file to find" file.html (PS i suck on bsd as much as on VBA).

I would like to automaticaly extract in Access each day when i press a button a table from a site. As for example, if possible, everytime i press this button i would like to import all the subjects discussed on the first page of tek tips like :

Title ///// Creation Date ///// Number of replies

Is this possible without the "copy-paste" formula? I can't find anything on vba that can do this and i'm not allowed to install BSD at work.

Thanks
 
These:
Automate .txt file import from web
thread181-1073615
DoCmd.TransferText HTML Import error
thread705-1219927
VBA Macro to Import Access Data from Web Server into Excel
thread707-1138109
running excel web query with password protected webpages
thread705-1251188

May (or may not :( ) provide you with some ideas.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top