Excel VBA - Download CSV file from URL

Well since you have it already in excel you can just go sheet .saveas(format_CSV) or something very similar.

Easy, just hack into the website and steal all their data so.

Serious answer: If the CSV file is not made available then you can't download it. What you can do is download a chunk each day and slowly aggregate these together.

Ah right, well do this so: http://stackoverflow.com/questions/3963475/http-post-in-vba

Just emulate whatever http request the save command is doing.

Copy and paste the vba. It shows you how to use the vba http library. You can do a http post the same as what clicking the save button does.

More useful stuff here: http://www.mrexcel.com/forum/excel-questions/67123-visual-basic-applications-save-file-website.html

What you are looking for is the http post request that happens when you click the save button. I don't think that is in the snippet you posted. This isn't my area of expertise, maybe a web developer could give you better advice.

Once you do find the post request however, you can use the vba stuff I linked earlier to download the file.

That looks more like it. So just put that http post stuff into the vba, something like below. You will have to finish it off yourself

To get stuff to appear formatted nicely on this forum you gotta put code tags around it. This means code and /code in square brackets.

Disclaimer: Not my area of expertise.

Dim WinHttpReq As Object
    Set WinHttpReq = CreateObject("WinHttp.WinHttpRequest.5.1")

    Dim strURL As String
    Dim StrFileName As String
    Dim FormFields As String
    
       strURL = "http://put.your.url.here/"
   

       WinHttpReq.Open "POST", strURL, False
      
       ' Set the header
      WinHttpReq.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
   
       FormFields = "_blank" ' this bit comes from the http post target bit I think
    
       WinHttpReq.Send FormFields
   
    
       ' Display the status code and response headers.
       MsgBox WinHttpReq.GetAllResponseHeaders
       
       ' The response should contain the file!!! So save this to disk. 
       SomeBinaryObject WinHttpReq.ResponseText

       SomeBinaryObject.save() ' i totally made this bit up

I basically did 99% of it for you -.-

Which bit do you have trouble with?