Get Files from FTP Site

[robcarr]

Dear All,

This is more of a testing water question, I found out recently that all my files that I have to deal with in the morning are available on an FTP site, I was wondering how easy it is to access/get the files from the site at a certain time of day, and also what the coding would be, I don't know any info about the site as yet(still waiting on this), I was just wondering if anybody else does this and how easy it is to get files from the FTP site.

Any comments/suggestions would be greatly appreciated.

thanks in advance

 

[oharab]

Try this cute little function:

Private Declare Function DoFileDownload Lib "shdocvw" _
(ByVal lpszFile As String) As Long


Sub Download(strFTPPath)

Dim sDownload As String

sDownload = StrConv(strFTPPath, vbUnicode)
Call DoFileDownload(sDownload)

End Sub

All you have to do is pass the full ftp path to the file and it will bring up the file/save dialog and will download it for you.
I am looking at some code that could make it a totally automated process, but I will let you know.

B ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------

 

[oharab]

I have a file which will connect to an FTP server, download the files you want to where you want, then close the connection without you having to do a thing!

I will put it on my website as soon as I can, but if you give me your email address, I will send it to you.

B ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------

 

[robcarr]

My email address is robert_carr@btinternet.com

 

[oharab]

Robert,
I've emailed you the file,
To anyone else, if you want this file have a look on my website for FTPmdb.zip
The file contains routines to connect to FTP servers, download files and then disconnect.
If enough people want, I could put a front end on it so that users can select their own files to download.



Ben ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------