We help IT Professionals succeed at work.

Download file from remote ftp site via VBA (Excel)

8,889 Views
Last Modified: 2016-11-02
Hello experts,

I have been downloading a certain .csv file from a remote ftp server through the command prompt. (An IT guy showed me how to do this when the standard way of accessing the ftp server using my web browser no longer functioned properly.)

I would like to be able do this with VB but after trying the dozen or so similar cases that I've found on your site, I'm not having any luck. The site is username/password protected. I use the site for download only (not uploading any files). Have you seen any idiot-proof ways of handling this?

Thanks, HB
Comment
Watch Question

Top Expert 2010
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Wow. You guys are great!  First shot. Thanks, egl1044, works perfectly.

Author

Commented:
Fast and flawless. Truly great. Thank you
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.