Can This FTP Download VBA be Modified for FTPS

I had this question after viewing Download file from remote ftp site via VBA (Excel).

I desperately need to find a solution to automate downloading files from an ftps site.

I have tried implementing this solution, but it is always resulting in fail.  I am wondering if it is because this is designed for ftp and not ftps?

I have no experience with this type of code; my experience is pretty basic, so I am not sure if this is resulting in fail because this is designed for ftp and not ftps or if it is something else.

I have verified that I calling it correctly, I have even tried different folders and files on the ftp site, but no luck.
Who is Participating?
Bill PrewConnect With a Mentor Commented:
Unfortunately, no it can not.  WININET.DLL can't support FTPS protocols.

If you want to roll up your sleeves and learn more I'd recommend looking at WinSCP.  It is a Windows FTP client that supports automation form VBA.  Take a look at these links to learn more...

Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
Besides WinSCP, I use Move it Freely FTP client with Access for sFTP and FTPs,

rsburgeAuthor Commented:
Thank you both for the comments.  I apologize for the delayed response; we are in the middle of a release and I forgot about this question for a few days.

I will dig into both suggestions and see what I can figure out.
Bill PrewConnect With a Mentor Commented:
Just another thought as I reread this thread too.  You may find that if you are using the right FTP client software that you don't have to do any fancy VBA scripting, etc.  Many of the popular Windows FTP clients (yes, some cost a little money but typically worth the investment) contain a scripting or automation toolset that can be easier to use than trying to "control" the transfers from the outside via Powershell, VBA, BAT, of VBS scripts.  WinSCP as I mentioned above also has this capability...

Jim mentioned MoveIT, but that vendor also has a solid Windows client offering too that you might look at as another option.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.