Comparing workbooks

[22strider]

Hello Friends

How can I compare two workbooks for the worksheet names?

I have two workbooks.

Workbook "A" has about 120 worksheets and workbook "B" has about 50-60 worksheets. Worksheets in "B" are also there in workbook "A". I need to find out which worksheets in "A" are not in "B". Worksheets in "A" and "B" have same names.
Note: I don't need to comare the data. Only the worksheet names.

Thanks

 

[cornflakegirl]

You could use the code on this thread http://www.mrexcel.com/archive2/3000/3389.htm to list out the worksheets in each book - then use VLOOKUP to compare them?

Of course, it depends what you're going to do with the information when you have it. That will probably influence the best way to do it.