Access Vba Download File From Internet

Hello, I've created a VBA macro within excel that points to a webpage using the InternetExplorer object. From here I wish to click on a button that will download a.csv file. Right now clicking on the button causes the information bar to popup due to the security settings. It appears that the button has a java script behind the scenes that actually creates the.csv file, but IE is blocking my access. I'm hoping to do one of the following to get around this but don't know how to go about it: 1.) Figure out how to disable the information bar programatically (perhaps by changing the security settings temporarily, or by telling the info bar to allow access) 2.) Try to mimic right clicking the button and use a 'Save Target As' approach. Does anyone know how to go about this? If this is in the wrong forum please let me know.

• Excel Vba Download From Website

Excel Vba Download From Website

Hi Several years ago I would often get some files on the web using VBA. I hope that it is helpful. The following code get a MP3 file from an URL.