Check if file exists on FTP server?

[Richard Edwards]

Morning all,
I would like to be able to check if a file exists on an FTP server and do
something if it does and nothing if it doesn't,

I have no idea if this is possible in VBA or if it is the best solution.

Any suggestions?

Thanks

Rich

 

[Dick Kusleika]

Morning all,
I would like to be able to check if a file exists on an FTP server and do
something if it does and nothing if it doesn't,

I have no idea if this is possible in VBA or if it is the best solution.

Any suggestions?

Rich

Read this http://www.dailydoseofexcel.com/archives/2006/01/29/ftp-via-vba/

It creates a batch file that does the ftp business, then runs it. You'll
need to figure out what would be in the batch file to detect the existence
of a file (I'd tell you but I don't know) then adjust the code.