Download of the file from macro
 

Hi there

I can start the download of the file using the Workbook.Open
Workbooks.Open "ftp://ftp.my.com/1.zip"

However, how can I handle the error message in the case that the file
I am looking for (1.zip) does not exist?
Thanks a lot

Cheers
Johny

Download of the file from macro
 

On Error Resume Next

Workbooks.Open "ftp://ftp.my.com/1.zip"

On Error goto 0

--
Regards,
Tom Ogilvy

"John Elink" wrote in message
om...
Hi there

I can start the download of the file using the Workbook.Open
Workbooks.Open "ftp://ftp.my.com/1.zip"

However, how can I handle the error message in the case that the file
I am looking for (1.zip) does not exist?
Thanks a lot

Cheers
Johny