Excel macro load web page and download file

Thank you for pointing out the issue. It seems that for some unknown reason, Google accidentally marked the file as a virus! I have updated the link, so now you will be able to download both files. Thanks for this wonderful file. I have a question, when i download multiple files through link, the files are getting download but it is corrupted. Links are from google drive. No, the above macros will not work with websites that require logging.

Those cases require a different approach. Check, for example, this code for logging. I need to download recordings from my dialer, will it work if so what I need except Microsoft Excel on my system. Sorry to ask a very basic question. As long as you are using Windows, then Excel is the only software that you will need.

Just download the sample files, add your URLs, specify the download folder and click the download button. Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page. Replace All. Your macro will change to one line per instruction. Install iMacros for Firefox. Avoid using the Chrome and other browser versions as they lack important features.

After installing, you will find the program in your View Sidebars menu. In iMacro, open Current. It does not matter because you will give your macro its own name.

Select Edit then Edit Macro. Paste your macro into the editor. With Sheet1. The data we are after currency exchange rates will appear in the cells B to B We could then use a code similar to that below to get the required values:. Cells , 2. You can download the file and code used in this article from the link below:. See also:. If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me.

Also please visit my website www. Your email address will not be published. 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.

Thread starter GillB Start date Mar 26, Status Not open for further replies. GillB New Member. Hi, I'd appreciate any help on this. Stream" oStream. Open oStream. Write WinHttpReq. ResponseBody oStream. After that I need to open the file automatically and then import the data into another file. I'm stuck just on opening the file, not the importing of the data In and ideal world I would have a macro that when the user clicks the button in the report workbook it would automatically to the following steps: 1.

I'm sorry I have nothing more to give on this, but any help at all would be very welcome. Thanks GillB. Deepak Excel Ninja. Mainly WinHttpReq.