Gurus,

Please note that I have searched far and wide trying to piece up some VBA code but have failed miserably.


In Excel, I have COLUMN A populated with 500 URL links (all intranet urls) that have the following format: http://testportalwps/search/Pages/Pe...lts.aspx?k=411

The urls are all the same and the only thing that changes are the 3 digits in the end and they are not sequential.

All these urls open up to a webpage where I would like to extract certain pieces of information like First/Last Name, Telephone Number, etc. into COLUMN B.

I know I can do "Get External Data From Web" in excel but that gives me too much information plus I would have to plug that url in every time.

Any other ideas please? I was thinking if I could get the entire source code of each of the webpages into COLUMN B, I could then regex out the info I need. Unless anyone has any easier method.

Thanks in advance.