vba automatic ie download

[macdos01]

Hi all,

Although not quite a trigger betting question I have a macro which automatically uses IE to download a particular file. When downloaidng a file the 'file download' popup always appears with the save or open options. I have searched ages to find a way to either handle the popup cleanly (i.e. not using sendkeys or a macro recorder) or to prevent the dialog box popping up at all and for the file just to download to the default location.

I have found sites which claim to solve the problem both ways. In terms of handling the popup by getting a handle on the window and then a handle on the button - this is cool but when it comes to clicking on the button by using its handle the code has not worked.
In terms of adjusting IE's settings to just download the ifle and not prompt the user I have adjusted settings that make sense to me but the popup still appears.

If anyone has dealt with this situation and has an easy answer that would be appreciated. Thanks in advance.

[Shaun]

Have you tried AutoHotKeys, when you speak of handles and such i am sure you have, is it possible to list the site so i may have a go at doing what you want.

[macdos01]

Thanks for the response. I managed to solve it - it was quite silly I had multiple versions of IE installed, so the settings I was changing wasn't doing as intended.