Hi all,

I need to read a page from the web and import it in Excel,
programatically (ie. thru a macro). This page contains some text that
have hyperlinks... A typical example of the page is:

---------------------------------------------------------------------------
Sample Page with Links

Text line 1....
Text line 2...
......
.....
Link to Data Set 1
Link to Data Set 2
......

----------------------------------------------------------------------------


The lines "Link to Data Set 1" and "Link to Data Set 2" are links to
another page(s). I need to get THESE LINKS into the Excel sheet, along
with the text. Is this possible at all?

I am open to experiementing with WebQuery or any other method,
including editing the .iqv file manually, if that will work.


Alternative 1:
If it is simply not possible from within Excel, the first workaround
is to try to get the source page of the web page. Is it possible to
get the Source of the web page using WebQuery or any other methods in
Excel VBA?

Alternative 2:
Any other roundabout method of using other tools such as PERL etc, and
finally getting them into Excel?


Please note:
The option of copying manually by doing a select all and pasting into
Excel or from IE 6 using Right-mouse-button option of Exporting to
Excel is not a solution in this case, because, I need to access a
whole lot of such pages (as given in the sample above) - about
thousands of them... (over a period of time). So it has to be done
programatically.

Advance thanks for any & all feedback.

Thanks & Best Regards,
-feltra

PS: I am just a beginner in Excel VBA and learn mostly by using
Recorded Macros to understand whats happening, so please bear with me
if i take time to understand... thanks.