Hi

I'm very much in need of some help. I'm trying - with no luck - to write a macro to do some data extraction for me. I have a column (B2:B1686) with URLs from which I would like to extract data to my work sheet.

here is an example of a url: http://ieee-emf.com/viewstudy.cfm?ID=1

What I specifically want to do is in 11 columns, say, from E to O to copy the content of the table in midle of the website.

So that I'll get the values from the table copied to the row corresponding to the specific URL in my worksheet.


the url ID Number Study Type Model Details Findings Status Principal Investigator Funding Agency Country References Comments
http://ieee-emf.com/viewstudy.cfm?ID=1 1 In Vivo some txt some txt etc etc etc etc etc etc often empty, but sometimes with some txt
.. .. .. .. .. .. .. .. .. .. .. ..


Thanks in advance
Jaco