How not to open broken links

Hey, i've been working on a workbook which allows the user to import values from a large number of external workbooks. The workbooks are located in a filestructure separated by month. My workbook lets the user choose a prefix and month, which manipulates the filenames the macro gathers data from.

The code is simply reapeating this line arround 60 times :

Range("B" & iColum").value = sFilename

However, sometimes the external workbook does not exist which causes excel to ask for "Update values: filename.xls" and allows the user to browse for the file.
I do not want to user to have to be promted that, just simply ignore it and returne a empty cell.
If my macro does not find the workbook, it is not there. So its just annoying and time consuming to have to click cancel every time a workbook can't be located.
Is there a way to disable this promt, or to search the folder for files first so my macro does not try to open it?


Thanks for any help.

Joakim

Joakiml
Something like

Please Login or Register  to view this content.