Possibly look at Tools=Get External Data = Create a web query.

You can turn on the macro recorder while you do it manually. then modify
the code to loop through your list of links and extract the URL, sending it
to the web query (with a new destination).

--
Regards,
Tom Ogilvy


"Dan" wrote in message
...
Hi there,

I do have (many) links with HTML text formated in tables.
I would like to convert those links (pages) regularily to an
excel file just containing parts of the original HTMP table.

What is the best way to achieve this? Cut and paste is out
of the question. There are too many links.

Any pointer is welcome.

Thanks a lot

Dan