Hi all,
I have two excel workbooks.
As part of a bigger automation there is a step whereby I want to get all the worksheets in Workbook1 and compare them against a list of all the worksheets in Workbook2. If a sheet from 1 doesn’t exist in 2 then I want to write that sheet to an output file.
How would I go about comparing the two worksheet lists?