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

On Error Resume Next

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

On Error goto 0

--
Regards,
Tom Ogilvy

"John Elink" <[email protected]> wrote in message
news:[email protected]...
> 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