How to check if a file exists in an ftp folder

Hi all,

Do any of you guys (and gals) know how to check via vb if a file in an ftp
folder exists?

Thanks.

Will you know the file path when the code is run?
What is an ftp folder?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"LL Cool A"
wrote in message
Hi all,
Do any of you guys (and gals) know how to check via vb if a file in an ftp
folder exists?
Thanks.

Yes, I will know the file path. The folder is located on an ftp site.

"Jim Cone" wrote:

> Will you know the file path when the code is run?
> What is an ftp folder?
> --
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware
>
>
> "LL Cool A"
> wrote in message
> Hi all,
> Do any of you guys (and gals) know how to check via vb if a file in an ftp
> folder exists?
> Thanks.
>

Well, I am still ignorant, but give one or both of these a try
and see what happens.
Replace the file path shown in the function calls with the
correct file path.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


Sub CallFirstFunction()
Call FindFile("C:\Documents and Settings\user\My Documents\File Name.xls")
End Sub

Function FindFile(ByRef strPath As String)
Dim strFile As String
strFile = Dir(strPath)
If Len(strFile) Then
MsgBox "File Exists"
Else
MsgBox "File does not exist"
End If
End Function
'------------------

Sub CallSecondFunction()
MsgBox ReportFileStatus("C:\Documents and Settings\user\My Documents\File Name.xls")
End Sub

Function ReportFileStatus(filespec)
Dim fso As Object
Dim msg As String
Set fso = CreateObject("Scripting.FileSystemObject")
If (fso.FileExists(filespec)) Then
msg = filespec & " exists. "
Else
msg = filespec & " doesn't exist. "
End If
ReportFileStatus = msg
Set fso = Nothing
End Function
'-----------------------------------



"LL Cool A"
<[email protected]>
wrote in message
Yes, I will know the file path. The folder is located on an ftp site.

"Jim Cone" wrote:
> Will you know the file path when the code is run?
> What is an ftp folder?
> --
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware
>
>
> "LL Cool A"
> wrote in message
> Hi all,
> Do any of you guys (and gals) know how to check via vb if a file in an ftp
> folder exists?
> Thanks.
>