Help with workbooks.open

Hi I am using the vba command

workbooks.open(filepath & file)

I get an error message when the specified filepath and file combination do not exist, as you might expect.

Is there any way to ignore this? The rest of my code is a set of loops to change the file name, following a structured format, so I know that certain file names don't exist whilst others do. I only want it to return data from files which do exist and ignore ones that don't.

Thanks

The quick solution is like this

Please Login or Register  to view this content.

Hi, thanks for the replies. I tried both approaches my code now skips the first file it can not find but for the next file it still gives me an error.

Here is my complete code

Please Login or Register  to view this content.