View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Emily Edgington Emily Edgington is offline
external usenet poster
 
Posts: 16
Default "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?