Home |
Search |
Today's Posts |
#1
|
|||
|
|||
File not found prompting
Is there a function 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 the following, thinking it was a long shot, and of course, it was: =IF(ISERROR('R:\reports\current\[IS_10001.xls]Sheet2'!$B$12),"Not found",'R:\reports\current\[IS_10001.xls]Sheet2'!$B$12) I would like to avoid using VBA for this if possible - 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 | |||
I Visual Basic Error "File Not Found" when Excel opens | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
#REF,ISERROR, File Not Found question. | Excel Discussion (Misc queries) | |||
How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |