Save file from web page

[agibsonsw]

Hello.
I'm using the following code snippet to obtain an Excel file from the internet:

Code: Select all

Set ie = CreateObject("InternetExplorer.Application")
    With ie
        .Visible = True
        .Navigate "http://www.bankofengland.co.uk/statistics/yieldcurve/ukblc05.xls"

This gives me the Open/ Save dialog. Can I choose Save without having to click the button?
(I tried SendKeys unsuccessfully.)
Is there another way to do this without automating IE?
Thanks, Andy.

[Jan Karel Pieterse]

You can simply use this:

Workbooks.Open "http://www.bankofengland.co.uk/statisti ... kblc05.xls"

[agibsonsw]

That's great!