Is it possible to extract particular pieces of data from a list of URLs in Excel 2010?

[wlu91]

Hey All,

I'm wondering if it is possible to extract just particular pieces of data from a list of URLs in Excel 2010. Let me explain what I mean. So, I have a list of ~700 organizations and I have their URLs on the adjacent column:

Capture.jpg

Now what I want to do is get only the organization presidents' names and email addresses on the columns adjacent to the URLs on the same sheet automatically. For example:

Capture2.jpg

I wish to automate this process because 700 organizations is a lot to go through. Until now, I still haven't figured out a macro/VBA to solve this problem. Is it even possible to just get the presidents' names and email addresses next to the URLs automatically? If not, is it possible to automatically get the text content of the URLs. That'll be good enough since I can split the data after getting the text content of the ~700 pages. Think I'll paste the link of the document URL here for you as well in case you want to test your formula/VBA/etc.:

https://www.dropbox.com/s/nmbrlmil5c...anizations.xlt

Thanks for taking the time to read this thread and help out.

[morevijay1982]

use mid function

[Sean Thomas]

Hi, you can do this with VBA,
i have done some work on it already.
My code so far runs through each URL, opens internet explorer and pulls the data required.
It work well on each line, but when i run it to loop through the 700 it errors. I dont have time at the moment, but i will take another look later today if i get a chance.

[Sean Thomas]

Hi, I have added this code which will search through all the URL's on sheet 2

Please Login or Register  to view this content.

[FDibbins]

Hi and welcome to the forum

Please upload a sample of your workbook, not a picture of your data.
Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

Also, plerase upload your file to the forum, not all members are able (or willing) to access file hosting sites