Ignore error while opening Excel workbook

[HATEMHUSAM]

I've an Excel VBA Code, that Code will Merge All Excel Files located in one folder. I need that Code to ignore any files that does not open for one reason or another like, the file is corrupted or not compatible or ....

the code is :

Please Login or Register  to view this content.

I'm thinking of something similar to "if statement", if the file could be opened and read from excel go ahead, other wise go next file in that directly.

[joe31623]

The line: "On Error Resume Next" will ignore any error and move to the next line (often ill-advised, but occasionally useful).

Remember to "turn that off" with the line: "On Error Got 0" at the end of the code that you do not want that effect.