Macro that runs when a sheetname in a file does not exist

Hi Guys!

I am looking for a solution to a problem i'm facing in the code below I want to import data from a file if the file name contains "Test". If the filename contains "Test" VBA should unprotect the sheets and look for a sheet called "Check test".

This is where the problem starts. Not every file called "Test" has a sheet called check test. I would like the macro to move on to the next workbook (and preferably give a message) if this sheet does not exist in the file. Please help out!!

Please Login or Register  to view this content.

Originally Posted by PCI

You have already a test done to check if the worksheet exit

Please Login or Register  to view this content.

What do you need more ???

This doesn’t seem to work for Some reason...