Hi All,

I have a workbook which contain links to other workbooks, these links refer to files which are not yet created as they produced daily, so the formulas I have work great with closed workbooks, however becaues the future files do not exist yet when I update workbook links in excel it will open a popup window to search for the file due it being not found.

So I am wondering if there is a way in VBA I am able to create an error handler, even if it means I have to set up each file path as a string to refer to (which I would be prepared to do if abosolutely necesary)

Just to clarify I'm not looking to disable the message about updating workbook links. Wanting to disable the "File not found" pop up box that asks me search for the file.

Thanks!