Solved

download a ftp file through vba

Posted on 2013-01-16
5
623 Views
Last Modified: 2013-01-24
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
Comment
Question by:iamnamja
5 Comments
 
LVL 9

Expert Comment

by:TazDevil1674
ID: 38783432
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
 
LVL 16

Expert Comment

by:AlexPace
ID: 38783581
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
 

Author Comment

by:iamnamja
ID: 38783944
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
 
LVL 16

Expert Comment

by:AlexPace
ID: 38783994
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
 
LVL 12

Accepted Solution

by:
Jeff Darling earned 500 total points
ID: 38784076
Here is a sample that  works.
Sample-FTP.xlsm
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question