|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
November 21st, 2005, 08:18 AM
|
|||
|
|||
|
Automatic collection of tables in Internet Explorer
Is it possible to create a VBA macro that will go to a specific web page and copy a table on that page into say, Word.
I want to create a macro that collects the UK Premier league football table from a site (http://news.bbc.co.uk/sport1/hi/football/eng_prem/default.stm). I will then use this table in Word to convert to text and format it for how I need it to be viewed. Any help or advice would be much appreciated. Thanks.
|
|
#2
November 21st, 2005, 02:32 PM
|
|||
|
|||
|
VB6 has an internet control that you can use to retrieve the html from a web page. You'd need to come up with code to extract what you want (screen scraping) from the page you retrieve.
I don't know VBA in word, but you can probably use the WebBrowser control to do the same thing. Search MSDN for information on the webbrowser control, I don't have a link handy.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Automatic collection of tables in Internet Explorer |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
