Excel 07 VBA to download from FTP

  • I am trying to retrieve files from an FTP site to save on our local network. I have never done anything like this before and don't even know where to start. Everything I have found through Google, makes no sense to me. Any help would be greatly appreciated :smile:

  • Re: Excel 07 VBA to download from FTP

    It is probably a matter of opening the site and selecting the appropriate link to the file. Without the source code it would be difficult to provide you code to access the appropriate file links.

  • Re: Excel 07 VBA to download from FTP

    This will create the IE object and open the website, but if it's pasword protected I would assume you need to include submitting the username and password in the code as well. I am happy to try to help you, but depending on your knowledge of VBA it may be difficult to get you where you need to go.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!