FTP Login

[Klatuu]

I am automating a daily process to download zip files from an FTP site.
Before I run it, I have to login to the FTP site. I get the dialog asking
for user name and password. Can I auomate this login in VBA?

 

[Douglas J. Steele]

There are a couple of alternatives for FTP shown at "The Access Web". I
think there's code in http://www.mvps.org/access/modules/mdl0037.htm to
handle authentication.

(If not, come to the private newsgroup)

 

[Klatuu]

Thanks, Doug. I will have to come to the group tomorrow night. I don't have
it set up here and I wont get home at a decent hour tonight. I am not
familiar with using script files as proposed in the module.

 

[Klatuu]

Doug,

I spent some time last night figuring out what you had posted. I got it
down, but I don't know if this is the right solution. What happens here is
some 40 to 50 zip files are put on the ftp site by one of our clients.
Daily, we move the files from the ftp folder another folder where they are
unziped to .dat files. We then use Pervasive SQL to export text files.
Right now, the process is to log into the ftp site, use MoveFile to move the
zip files to a staging folder and upzip them. It looks like I could get the
files then delete them; however, the possibility exists that between the get
and the delete a new file could be put on the ftp site causing that file to
be deleted before it is processed.

Also, I have tried writing a script, but I keep getting an unknown error.