Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"File Not Found" prompting
Is there something similar to DisplayAlerts that will allow me to skip the
"File Not Found" prompting to look for a file that is not found in a link? I have a summary workbook that pulls values from other Excel files (monthly bank reconciliations). We want to be able to open the summary and see what bank recs have not been completed yet, without having to sit through potentially 300+ "File Not Found" pop-ups. I have tried worksheet functions (and posted a message to the worksheet functions group, to no avail). I want to be able to set up the summary file for the entire year, so 12 tabs in the workbook, with links adjusted to point to different monthly folders. Obviously, if it is March, the December recs are not completed. I don't want to be prompted about that. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I install when "file ZF561407.CAB can not be found" | New Users to Excel | |||
Getting "compile error" "method or data member not found" on reinstall | Excel Programming | |||
"file not found" error message when launching source file | Excel Programming | |||
Disable "File Not Found" dialog box | Excel Programming |