Login and download a file vba

Log in. Hi All Please note that at the Chandoo. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post. JavaScript is disabled.

For a better experience, please enable JavaScript in your browser before proceeding. VBA Login to site and download file question. Hi all. I have been working on a code that will login to a website, go to specific page and download an excel file.

Where my code goes wrong is that i dont know how to save that excel file when the information bar at the bottom of the screen shows "Open", "Save AS" and "Cancel. I've tried using the "WinHttpReq" code that is out there to attempt this but it hasnt been working at all. If I am going about this code the long, wrong way, please let me know. I am a little new at this so any feedback is appreciated. However, it was mostly slow solutions and most were also convoluted.

Update: After a while I found a nifty solution using Microsoft. I thought to share the solution below for future reference. Users supply information and then make the calls. We were unable to develop in house with ftp. Is there an download manager add in for Internet Explorer that disables the prompt? I have not found one yet. This should 'click' Open file. Why not use it?

Because it's not reliable. The user sometimes switches the active window away. Is there a way to "SendKeys" to a specific window? Using WinHttpRequest. This should probably work, but it seems like it is a lot of work to learn how to use the WinHttpRequest, and to rewrite all of my code.

Maybe lazy people have more work Besides, debugging WinHttpRequest would seem to be much more difficult as the actions are not visible while in IE I can watch what is happening.

Theoretically, once I enter the fields in the web site I can use iMacros to download the file. The problem with iMacros is that it takes time to load and close. My VBA program is designed to download hundreds of files.

The solution is to use cURL rather than trying to enlist the "help" of Explorer. But instead of sending the response to a MsgBox you would open a file and write to it. Of course this is really using WinHTTPRequest and you already said in your question "that seems like a crazy amount of work" - so I'm not sure you will be happy with the solution. Password recovery. Recover your password. Get help. How to develop live currency converter in Excel? Download Currency Converter. Call Center Audit Form Download.

Blog Posts. Share on Facebook. Follow us. Please enter your comment!