Automate "Save" from IE11 "View Downloads" dialog

I am writing an Excel vba macro to automate the process of downloading .csv files from Yahoo Finance.

My process flow is:
1. Open IE
2. Navigate to the link
3. The link automatically pops up "View Downloads - Internet Explorer" dialog box and prompt to "Open" or "Save"
4. Click "Save"
5. Close
6. Repeat 1-5 with different link

So far I have only been able to complete until step 2 and stuck when the "View Downloads - Internet Explorer" appears.
Have been searching high and low but couldnt find a solution to get past the IE "View Downloads" dialog box.
Greatly appreciate if anyone could point me some directions

Thanks =)

Thanks for your reply!

I was using different method to download data from Yahoo Finance (Workboos.Open(URL)) until recently when they changed their API.
They seem to block any access that identifies itself as Excel so I thought the only way was to automate IE and download it.
The example works with slight modification

Please Login or Register  to view this content.