How to open up internet explorer and download file

[MetLife]

Hi,

I have a file which can be accessed through internet explorer. Do you know how to write a macro to download the file through excel?

I'm imagining maybe shell command might work.

Thanks!

 

[Rijnsent]

Hi MetLife,
did you search the forum? There are plenty of examples, e.g. https://www.mrexcel.com/forum/excel-questions/353006-download-file-excel.html and https://www.mrexcel.com/forum/excel-questions/352868-download-file-web-using-vba.html
Cheers,
Koen