VBA and IE9 - override the "open, save, cancel" pop-up

Hi,

I am trying to build a vba feature to download .csv files from a site with login, that should run on a computer, only adressed for this feature to run in the background, plus having a pptx show running in the foreground, with updated data from those files.

every hour or so, a sub should be called, that will open IE9, log on to a website, navigate to different sub-sites, where a button must be clicked to download a .csv file with new data. (there is no direct URL link that automates the download, the button must be pushed)
so far so good, I can manage to log on, navigate to the desired site and press the button - but I cannot avoid the manual push of the pop-up where I have to choose "open, save, cancel" (I want to save them to the desktop as default, where another part of the code will pick up the files, handle the data and delete them)

how do I avoid that pop-up? SendKeys to press "save" is not desired, since that would require IE.visible = true, correct? I want it to run in the background, and I need it to run stable 24/7 which I dont find SendKeys to be...
Is it possible, or have Microsoft disabled the feature? In chrome, I am allowed to disable the pop-up under settings, downloads, disable "ask where each file..."

before suggesting any other coding language to deal with it, I have NEVER done any other programming than VBA in Excel, with a few links to pptx and IE, and hopefully this project should not take me too long to finish.

Best Regards,
Per Olander

Similar problem here. How did you resolve the problem?