Vba ie file download window

It seems that URL is redirected to a server which check if user is authenticated before starting download. URLDownloadfile is not aware that a redirection should take place and starts immediately to download file.

This was done thanks to Sidd Harthrout. Many thanks for the very clear comprehensive code which i slightly modified. Original code can be found on this forum or on his web site. Here are the steps. The "Save AS" windows remains open as if click was not received. You call this "VBA" but it looks like. Net code - what program are you coding with? Visual Studio, or an Office application, or something else? If VS, is this a Windows Forms application?

Also, please explain the authentication; you can pass network credentials along with the connection if the website supports it. If it only supports forms authentication then you have to be able to navigate the site and perform a login before you can download the file. Reed Kimble - "When you do things right, people won't be sure you've done anything at all".

It requires identification login the 1st time you attempt to reach intranet. Then if you close ie and relaunch it you don't need to login again. I am not experiencing authentification pb. Please replace it with your link. Now depending upon the link that you specify, you might see the one of these two download windows. Based on the download window that you see you will have to find the window handles based on the pic shown below.

More details on the blog link that I gave. If you save it in any other location then amend that in the Shell statement below. FILE : The file can be downloaded here. I think I came up with a simpler solution: when the download bar appears in IE9, just by-pass it by displaying the "real" Download Pop Up window. All you have to do next is click on "Save" or "Open". There might be pretty ways to do it, but I simply send a key sequence to move the focus on desired option and then press enter.

Your Application. Sendkeys just needs a tweak. Below is the code I am using so it is tested on IE Let me know if this doesn't work and you need help adding the Shift back in. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 9 years, 5 months ago. Active 2 years, 10 months ago. Viewed 16k times. I am writing a macro to download a csv file from my company's internal website.

Links If alink. Click 'waitForLoad Application. Improve this question. If I am not wrong then the only place on the web which extensively covers on how to interact with the IE File Download is here There's one of many examples here cpearson. Range "D18". Print " Clicked Save button" End If If hWnd Then 'Set function return value depending on whether or not the ' already exists' popup window exists 'Note - the popup window is a modal dialogue box and a child of the main Save As window.

Both windows have the 'same class and caption Save As. This may present a problem in finding the popup window, however in all tests 'FindWindow has correctly found the popup window. Do you want to replace it? No, not when you click save, only when you click open. However, I have another macro is calling these files and they need to be in file format 56, which is Excel Norie Well-known Member. The problem with opening the file is probably caused by a security setting.

I think it was introduced in Excel You can change or turn it off and as far as I know doing so has no adverse effect. I can't recall the exact setting but it's something to do with unrecognized file formats.

Norie said:. Activate Application. Close Next C End Sub. Well I turned it off using Group Policy Editor, but that was only because it was available. I did see the registery option though. Whichever method you use if this is going to work for all users then they'll need to change the setting.

You might even need to get someone in IT to do it. PS I tried resaving etc but could never get it to work, it was only when I stumbled on this setting that I resolved the problem. You must log in or register to reply here.

Similar threads T. Question SendKeys doesn't interact with popup window. Replies 0 Views Saturday at AM tjdickinson.

Solved Help with error handling, I need to retry the step. BalloutMoe Sep 4, Excel Questions.