Downloading a CSV file from Website using VBA

[ExcelTrader1]

I'm looking to download a file from the site: "http://www.m-x.ca/endOfDayData/", with the file address being "http://www.m-x.ca/endOfDayData/DataBDM2013-11-26.csv". When I use the code

 ActiveWorkbook.FollowHyperlink Address:="http://www.m-x.ca/endOfDayData/DataBDM" & Format(Now, "YYYY-MM-DD") & ".csv"

I get a pop-up from "Windows Security" Titled "Connect to www.m-x.ca" and requesting I enter a User & Password with the checkbox "Remember my credentials". When accessing this link using IE10, it asks whether I'd like to save or open, but no user/password. I get the impression this is a Windows issue, any ideas? (also, I'm using Windows 7 Home Version)

 

[John_w]

This worked for me:

Sub Get_File()
    Workbooks.Open "http://www.m-x.ca/endOfDayData/DataBDM2013-11-26.csv"
End Sub