If The Sheet it A Newly Opened File does not exist

[FLani]

hi. Im trying to build a macro code, though i already figured out the if and else statement if the workbook does/does not exist i need help in inserting a code that if the sheet in that opened workbook does not exist it will just close the file and proceed to the next data.

[FLani]

I think it's because my code already contains an if function for opening the workbook that i fails in the if function if the worksheet exists

Please Login or Register  to view this content.

[FLani]

Up this thread

[FLani]

Up this thread