Download of the file from macro

  • Thread starter Thread starter John Elink
  • Start date Start date
J

John Elink

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Test for file on server 1
Macro to open files using cell reference 3
Code for file download 2
File Download - Security Warning 5
Open a File and Run AutoOpen Macro 8
Exit sub only and only if there is an error in the procedure. 2
Call Outlook from Excel macro 1
Problem with pivot table when workbook is protected 1

Back
Top