Get HTTP MetaData into Excel

Hi Everyone

Can anyone offer a way to do the following:-

Get HTTP MetaData into Excel

1. Take list of URLS
2. Enter to XLS Sheet
3. Have XLS (VBA Function) look up each URL
4. Pull down Meta Title & Meta Description of each URL
5. Display Result in table

I have found many resources which do some, but not all of these reqs. Also "Get External Data" is not sufficient as it only gathers on page data sources, and I am looking to import the Meta Data from a list web pages into Excel.

As a newbie to XLS - This is my first post to the forum so thanks in advance for your help.

• There must be a XLS Champion out there who knows how to do this?

Cheers

XLS_GUNDA