Code to skip a line

[StKi1da]

This is my first foray into VBA macro - so forgive me if things are a bit messy.

I have a list of excel documents, *most* of which are based on a template and the code below opens each excel file, pulls the required data from defined cells and drops into the summary document.

When it comes across an excel file that is not using the template the code fails. I'm guessing as the sheet it is seeking is not present.

I would like to add some logic so that if it opens a file which does not have the sheet name present it will close the file and skip to the next file (and perhaps insert "N/A" or similar to the summary destination cell.

Anyone able to help?

Many thanks...

Please Login or Register  to view this content.

[PFDave]

You could probably just get away with On Error Resume Next before your For x line, however this could mask other errors.

But please can you update your post to ensure your code is between the code Tags

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]