FTP Batch

[blueshark]

does anyone know of a good FTP program that can read a batch text file for downloading files?

I have a list of about 3000 files I want to download.

Eventually I'll incorporate into my database but I think I've found some code that will help me do it. I'm looking for a quick off the shelf thing for now though.

Seems simple enough just can't seem to find one.

 

[mdmilner]

Here's a good link:
http://www.mvps.org/access/modules/mdl0015.htm
Site is good for many references.

Here's the text though:
This will execute your batch file as it's written.

'******* Code Start *****
'This code was originally written by Dev Ashish
'It is not to be altered or distributed,
'except as part of an application.
'You are free to use it in any application,
'provided the copyright notice is left unchanged.
'
'Code Courtesy of
'Dev Ashish
'
Sub sFTP(stSCRFile As String)
'Usage Example:
'   call sFTP("C:\temp\test.scr")
'Sample SCR File for NT/Win95 FTP
'   lcd "c:\temp"
'   open ftp.someserver.com
'   anonymous
'   dash10@hotmail.com
'   cd public
'   binary
'   get dead.letter dead.letter
'   bye

Dim stSysDir As String
    stSysDir = Environ$("COMSPEC")
    stSysDir = Left$(stSysDir, Len(stSysDir) - Len(Dir(stSysDir)))
    Call Shell(stSysDir & "ftp.exe -s:" & stSCRFile, vbNormalFocus)
End Sub
'********** Code End *******

The *best* way to do this is actually here:
http://www.mvps.org/access/modules/mdl0037.htm

This exposes WinInet.dll which allows you to build a FTP process into a VBA or VB application. Other options exist also - I remember finding a sendkeys version.

Mike