I 'm not the orig. poster. I'd like to continue this quest. I submitted a
question in this discussion group. SEE How can I download from the web using
VBA.
--
rac


"Randy Harmelink" wrote:

I don't know if you're the original poster, but "downloading" and
"opening" are two completely different functions, and will most likely
require different solutions.

Specifics of how to do either would require more detail, since there
can be dozens of complications depending on how a given web site
presents/delivers the data.

For example, I often grab the "text" file of current stock quotes from
Yahoo's current quotes server. The easiest solution for me was to
just open the web page of data they create using the XMLHTTP method.
However, downloading the file would be a different process. And
opening it on the web would bring up a confirmation notice similar to
the one mentioned by the original message of the thread -- one reason
I avoid doing it with the IE object.

On Jun 15, 10:01 am, rac wrote:
This is what I want to do. How do I Download text file from website in VBA.