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

On Tue, 24 Feb 2009 11:18:53 -0000, "Richard Edwards" <(E-Mail Removed)>
wrote:

>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/arch...9/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.
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com