View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
uP..AND..DOWn uP..AND..DOWn is offline
external usenet poster
 
Posts: 1
Default Using Excel to report the TITLE of a webpage?

Hi,

I have a list of a large number of addresses from a UK news website in a
Excel sheet.

e.g.

http://......./england/kent/485276.stm
http://......./england/kent/485277.stm
http://......./england/kent/485278.stm

etc. etc.

These are down in a column (A1....A800+). As I'm trying to pick out
particular news items, I need a function to return just the content of the
hypertext element "<TITLE". Is there an already defined Excel function that
could do this, or do I need to explore the delights of VBA, which I'm new
to?

Any ideas or help?

Many thanks,

Steve