FTP to put and get file using VBA

[GeorgeMar]

I want to put a button on my application that allows the
user to send me their Back End MDB and for me to put the
MDB back afterwards.

I currently put files on my site using ftp through DOS
CMD.

I am now trying to automate that through VBA, because
obviously, I don't want them to see the username and
password for the site.

Where should I start?

many thanks for your help
george

 

[Albert D. Kallal]

This should help:

http://www.mvps.org/access/modules/mdl0037.htm

and, also take a look at:

http://www.mvps.org/access/modules/mdl0015.htm

 

[GeorgeMar]

Albert

Thank you for that response. It works well. Thanks to
Dev Ashish et al.

Is it possible to get a progress bar similar to the .zip
download that shows how much time is remaining or a any
simple progress bar?

regards
george