Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I install when "file ZF561407.CAB can not be found" shelba New Users to Excel 0 August 3rd 06 01:16 AM
Getting "compile error" "method or data member not found" on reinstall Bp Excel Programming 1 April 23rd 04 04:42 PM
"file not found" error message when launching source file Lisa[_9_] Excel Programming 4 April 6th 04 02:54 PM
Disable "File Not Found" dialog box Sandy[_3_] Excel Programming 4 September 4th 03 03:05 AM


All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"