This is what I want to do. How do I Download text file from website in VBA.
--
rac


"xllentcharts" wrote:

Good morning!

Thanks largely to the excellent reference material posted on this site
I have succeeded in automating IE using Excel VBA. Thank you all. But
I have one small issue left to solve. My little Excel 2003 app uses
IE7 to navigate to a website where it attempts to open a text file.
So far so good but IE7 responds with a confirmation dialog asking if I
want to "Open", "Save" or "Cancel". Does anyone have suggestions how
to implement an automatic response to that question? I would like to
"Open" the text file.

Thank you for your thoughts.