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:
Excel 07 VBA to download from FTP
-
-
Re: Excel 07 VBA to download from FTP
is the site public access? Can you provide more specifics, please.
-
Re: Excel 07 VBA to download from FTP
No, the site is password protected. I currently use FileZilla to access the files.
-
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
Is there a generic setup you can show me?
-
-
Re: Excel 07 VBA to download from FTP
Code
Display MoreDim IE As Object Set IE = CreateObject("InternetExplorer.Application") 'create new instance of IE. use reference to return current open IE if IE.Navigate "your url here" 'go to web page listed inside quotes IE.Visible = True While IE.Busy DoEvents WendThis 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!