help_questions
Board Regular
- Joined
- Aug 22, 2005
- Messages
- 215
I have an excel report. The data from the report is from 4 external files(data files), which are created through the day at differerent times (1pm and 6pm). My report uses vlookup to get the report data from the "data files"
The report is macro based, but when I run the macro at 2pm, I get the
"File not Found" error, and have to click cancel. I get the "File Not Found" error, because the 6pm file has not been created yet. Is there a way to get around this?
The report is macro based, but when I run the macro at 2pm, I get the
"File not Found" error, and have to click cancel. I get the "File Not Found" error, because the 6pm file has not been created yet. Is there a way to get around this?