VBA code to import data from different SITES

[a1b2c3d4e5f6g7]

Hello,

I have a question about importing data's from different sites. I have to import names, functions and adresses from different sites.

Is it possible to write a vba code to do this and import it directly to different colums?

Thnx

Columns in example

[Xx7]

1) The easiest way would be to select "Data, Get External Data, From Web" then select the website.
However this may not give you the intended result. As long as all the data is included in the import, you could manipulate it in Excel

2) A more advanced method would be to use COM internet automation through VBA. This essentially involves reading the HTML code of a page and looping it to find the respective tags, values.. etc.

[a1b2c3d4e5f6g7]

The first method, iīm familiar with.

But isnīt it so, that in the second method. The tags and values are mostly the same?

Isn't their a way to write a code, that i only have the change the site names. And then import it directly in the different collumns, with the most common tags and values...?

[Xx7]

HTML coding will be significantly different for each site, therefore the VBA has to be adjusted to suit.

For example, on THIS website... Right click and select "view page source". That is the html code that you will be looping through to get the respective data.

[a1b2c3d4e5f6g7]

But ain't it possible.

That you for example write a code that takes it from a site and puts it in the wright colums.
And that i only have to adjust the variables, sites.

It's mostly this site: http://www.netwerknotarissen.nl/mijn...is/medewerkers. And i need the information from the employes.
But the company name differs.