Excel VBA Introduction Part 49 - Downloading Files from Websites
- Published on Nov 19, 2016
- PLEASE NOTE: The design of the website used in this video has changed since the video was recorded. This means that the code shown will no longer work for the website used. You can download both the original code and a revised, working version from this link www.wiseowl.co.uk/videos/excelvba/downloading-files.htm
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here www.lulu.com/shop/andrew-gould/introduction-to-excel-vba/paperback/product-23301058.html
By Andrew Gould
Download files here www.wiseowl.co.uk/videos/excelvba/downloading-files.htm
Excel VBA doesn't have a native method for downloading files from websites but you can declare an API function that will enable you to do this. This video takes you through the process of declaring the API function and using it in your code, along with a bunch of other useful techniques such as using folder pickers, creating folders with FileSystemObjects and opening a Windows Explorer window using the Shell function.