Excel VBA to access URL as Textfile
 

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

Excel VBA to access URL as Textfile
 

http://groups.google.com/groups?selm...wick.ac.uk& 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...sa05&output =
gplain


Regards,
Tom Ogilvy


Günter Kehrer wrote in message
m...
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