Excel VBA to access URL as Textfile

[Günter Kehrer]

When you see a page in Internet Explorer, in View / Source you can get
the content of the page as a text file with all the html codes etc.
This is shown in a simple text editor and can be saved as a text file.

How can I get hold of this data in Excel VBA by passing the name of
the URL and get back this data into one String-Variable ?

(Once I have the data in that variable I would like to parse through
this with simple string functions to fill the fields in my worksheet).
But the only way I have found up to now is to get the URL data into
cells, which is not what I want to do. I would like to have this
entire text in a variable within VBA code.

Thanks for any help in advance.

Günter Kehrer
(e-mail address removed)

 

[Tom Ogilvy]

http://groups.google.com/[email protected]&o
e=UTF-8&output=gplain

has one method. Watch word wrap. The URL should be all one line.
Reconstruct it in notepad and paste into your browser nagivation window.

Here is a simpler method:

http://groups.google.com/groups?selm=uqkGJaQu$GA.268@cppssbbsa05&output=
gplain


Regards,
Tom Ogilvy