open or download the workbook from the internet

[mrkhchan]

Hi All,

I want to open or download the workbook from the internet. but the path is too long so I can't use workbooks.open to open the file. I planned to download the workbook using IE object. but I wonder if I can directly open the workbook. Many Thanks.

the path of the WB:
http://www.bnb.bg/Statistics/StFinan...ION=SDMX_TABLE

I currently type the path to A1. and use the following code to download.

Sub getl()
Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate (Cells(1, 1))
End Sub