I have a vb that reads 8 .xls file locations into an array like this.

Dim myFiles(1 to 8) As String

myFiles(1) = "\\myDirectory\myFile1.xls"
myFiles(2) = "\\myDirectory\myFile2.xls"
myFiles(3) = "\\myDirectory\myFile3.xls"
myFiles(4) = "\\myDirectory\myFile4.xls"
myFiles(5) = "\\myDirectory\myFile5.xls"
myFiles(6) = "\\myDirectory\myFile6.xls"
myFiles(7) = "\\myDirectory\myFile7.xls"
myFiles(8) = "\\myDirectory\myFile8.xls"

It later reads through this array, and extracts data from each sheet and places it into a Master spreadsheet which we use to summarize the data. I don't think I can post all of the code, sorry this is a big program.

When any of these individual files are not set up correctly(bad path, corrupted, columns out of whack, or file locked as read only), my entire master spreadsheet comes up blank instead of telling me where the problem is.

To sum up what I need: When there's an error loading file(s), skip the file(s) with problems and load up the files that have no issues. Then display a MsgBox that tells which file had an error.