| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| download file of 200 name, addr.etc to excel file - how? please ad | Excel Worksheet Functions | |||
| macro to download a file. | Excel Discussion (Misc queries) | |||
| I need to download an exel spreadsheet file. (file extension :xls) | Excel Discussion (Misc queries) | |||
| Macro did not run after download file from net | Excel Worksheet Functions | |||
| Macro did not run after download file from net | Excel Worksheet Functions | |||
Linear Mode
