Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a macro that opens a file and pulls any outstanding tasks from the previous day. I have a problem when it is a new month because the previous month's file is called MyFileMarch2010. The macro now looks for MyFileApril2010. How do I capture the error and look for the previous month's file if it is the first business day of the month? Any help or suggestions is appreciated. -- Thank you Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run time error 53, cannot find file | Excel Programming | |||
1004 error - can't find text file to refresh ... | Excel Programming | |||
Excel cannot find file error | Excel Programming | |||
Cannot find file - code error | Excel Programming | |||
Automation Error: The system cannot find file specified | Excel Programming |