Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 700
  • Last Modified:

download a ftp file through vba

Hi,

I'm looking for a method to download a file from the ftp site through vba.  Any ideas on how to go about doing this?
0
iamnamja
Asked:
iamnamja
1 Solution
 
TazDevil1674Commented:
If you have Microsoft Internet Transfer Control as an available library this looks like the most elegant solution: http://officeone.mvps.org/vba/ftp_upload_file.html
0
 
AlexPaceCommented:
The inet control is nice in the simple case and the best thing is that it is free!
 
If you need to do secure stuff like FTPS with a client certificate or SFTP you can use Robo-FTP with vba.  Robo-FTP has its own scripting syntax but you can also control it with VBA using COM, see: http://www.robo-ftp.com/help/3.8/sample_vbscript.htm  However, it is not free.
0
 
iamnamjaAuthor Commented:
I don't seem to have Microsoft Internet Transfer protocol and also I would unfortunately need a free version.

Any way to do it with the references taht's already available in excel?  Only reason being is that I would need to send this macro to multiple people within the company and they would have to run it... i don't want to create issues with references/fees and such.
0
 
AlexPaceCommented:
Here is another thread where the guy is using API calls to do it from Access.  This method has its own issues but it might work for you: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27997253.html
0
 
Jeff DarlingDeveloper AnalystCommented:
Here is a sample that  works.
Sample-FTP.xlsm
0
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.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now