Test for file on server

[windsurferLA]

I use Excel'97 under WinXP-pro to automatically open a file stored on a
server. The command is:

Workbooks.Open FileName:= _
"ftp://12.34.567.890/public_html/Actions/DownLoad-UploadTest2.xls"

It works find if the file exists, but if not, I get a run time error
1004, and macro stops.

Is there a way to test whether or not the file exists before attempting
to down load the file? The following doesn't work.

If
("'ftp://12.34.567.890/public_html/Actions/DownLoad-UploadTest5.xls'")_
<> "" Then
Workbooks.Open FileName:= _
"ftp://12.34.567.890/public_html/Actions/DownLoad-UploadTest2.xls"
End If

 

[windsurferLA]

In prior post there is typo. error. Both file names should end in
"Test2.xls"