Thread: Check if file exists on FTP server?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
  
Posts: 595
Default Check if file exists on FTP server?
On Tue, 24 Feb 2009 11:18:53 -0000, "Richard Edwards"
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
Reply With QuoteReply With Quote