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.
Bookmarks