How do I check to see if a worksheet is in a different workbook?

[Doctor Dinero]

I have a master workbook that opens up many others. There are two flavors of target workbooks and I would like to auto determine which is which. I am hoping this can be done because each have unique spreadsheets within them. Is there an easy way to querry the workbook and if the sheet is there return "true"?

[Leith Ross]

Hello Doctor Dinero,

Here is an example. Due to the lack of details in your post, I can not offer you a specific solution.

This macro will check all open workbooks, except for the workbook the macro is in. Each sheet in every workbook is compared to two possible names: Sales Orders, Purchase Orders. You can change these to match the worksheets you will be checking for.

If a match is made then the Function will return either "Sales" or "Purchases" as the workbook type. Again, you can change this to what you will be using.

Please Login or Register  to view this content.