VBA - Can't get to download a file

[Ooalkman]

Hi there !

I would like to download a file from a website using VBA. The tricky part is that the file is generated after filling a form in the webpage and clicking on the submit button, so I don't know its name and address before download (meaning I can't use the URLDownloadToFile API). I've tried several things, so far I've got two problems :

1. Using a XMLHTTP request (as in this thread), I can't get to do the right request to trigger the download. I think the dynamic form is reading the webpage before submitting, adding some variables and I don't know how to simulate that with my request.
2. Using a HTMLDocument with IE, I manage to trigger the download but I can't download automatically, I have to interfere manually (and I'd like the app to run background which doesn't seem possible this way).

So anybody has a clue on this ? I have to admit i'm getting a little depressed.

 

[Ooalkman]

Victory ! I managed to download a readable file by errasing the

WinHttpReq.setRequestHeader "Accept-Encoding", "gzip,  deflate"

request. I was actually downloading gzip. I don't know in which part of the process the gzip is extracted and converted but the thing works now anyway.

Now I just have to solve my "timed out" problem. Oh, and I figured out it didn't work if I didn't send the good cookies requests, so I'm gonna have to find out automatically what thoses cookies are too. But hey, there's progress !