Webpage data retrieval

[ianclegg]

Can you help,

I am wanting to get data from the wikipedia website relating to countys.

I am able to automatically search wikipedia and load the page concerned using the following code

Function FindCountyName(area)
On Error Resume Next
Dim ie As Object
Set ie = CreateObject("internetexplorer.application")
ie.Visible = True
ie.Navigate "

http://www.wikipedia.org/wiki/"

+ area

End Function
The parameter area is passed to the function from a record already existing in a table. The data that I require is held mainly in a table on the website giving data about the town or area concerned e.g. Dewsbury

I understand that I need to address the data using HTMLElements but I have no idea how to code this.

I would be grateful for any help or suggestions to fix my problem

Ian Clegg

 

[CautionMP]

ianclegg,
This thread may be of interest. It's in the VBA Visual Basic for Applications (Microsoft) Forum and written for Excel but it demonstrates an idea.

Parse HTML code, create a table

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)