| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro-file could not be found
I haved a macro that copy information from a closed workbook. If the macro
doesn't find the closed workboo, i receive an error '1004': file......could not be found. Is there an code to avoid this error? Or, better...if there is an code that will display, instead of '1004' error, a message: "there is no entry for this day". Can this be done? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro-file could not be found
Perhaps something like:
Test = Dir("C:\Some File Path\Workbook.xls") If Test = "" then msgbox "There is no entry for this day" exit sub end if -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "puiuluipui" wrote: I haved a macro that copy information from a closed workbook. If the macro doesn't find the closed workboo, i receive an error '1004': file......could not be found. Is there an code to avoid this error? Or, better...if there is an code that will display, instead of '1004' error, a message: "there is no entry for this day". Can this be done? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro-file could not be found
Perfect!
Thanks! "Luke M" wrote: Perhaps something like: Test = Dir("C:\Some File Path\Workbook.xls") If Test = "" then msgbox "There is no entry for this day" exit sub end if -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "puiuluipui" wrote: I haved a macro that copy information from a closed workbook. If the macro doesn't find the closed workboo, i receive an error '1004': file......could not be found. Is there an code to avoid this error? Or, better...if there is an code that will display, instead of '1004' error, a message: "there is no entry for this day". Can this be done? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to copy value from 2nd file, if a word found in a correspondingrow of both files | Excel Discussion (Misc queries) | |||
| Macro cannot be found, but it is there? | Excel Discussion (Misc queries) | |||
| Macro cannot be found | Excel Discussion (Misc queries) | |||
| File Not Found menu pops up after I open a file | Excel Discussion (Misc queries) | |||
| How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
Hybrid Mode
