FTP Macro

[dave8]

I need to build a macro to FTP and download some files on a site (I have userid and password) to my computer. Is there a way to do this? There are specific files that I want to download, for example, fileA, fileB, fileC, etc. These files will be placed in my c:\folder1\subfolder2\..

Anyone familar with this to help?

 

[Tom Urtis]

You may want to consider providing a few more details about what you are dealing with. For example, for my website's domain I have an FTP primary account with my login name and password. With my server I maintain a couple dozen FTP accounts to serve my clients when large files are involved.

I use FileZilla for this. So, would part of your request here involve an external app such as FileZilla to open and login with, and also, would you be signing in as the primary account holder with a particular subaccount relating to the files you want to grab. I am not so sure that VBA and/or API would be a reliable conduit for what you want to do, depending on how complex the login name, password, and domain ftp address are to convey to the medium by which you'd be pulling in the files.

 

[dave8]

I am using FileZilla and will be signing in as primary account holder. I have the userid and password along with the ftp domain address. Once signed in, through, I will need to provide some parameters for downloading specific files. That is, I will need to go to a specific folder on the remote site and download certain files.

With this information, is it possible to do this in VBA?

 

[Tom Urtis]

I am using FileZilla and will be signing in as primary account holder. I have the userid and password along with the ftp domain address. Once signed in, through, I will need to provide some parameters for downloading specific files. That is, I will need to go to a specific folder on the remote site and download certain files.

With this information, is it possible to do this in VBA?

I honestly don't know and have not tried it. At this point, a google search for opening FileZilla programmatically would be a logical next step. I'll keep an eye on this thread and do a little muckraking myself, as it's been a topic I've wondered about, but just never got around to.

 

[Scott Huish]

Just a thought, but since you can access FTP from the command prompt, I was just wondering if there was a way you could utilize this from VBA.

http://www.nsftools.com/tips/MSFTP.htm

May have to try this later.