View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xllentcharts xllentcharts is offline
external usenet poster
 
Posts: 1
Default Download text file from website

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.