Master workbook with sub workbooks as tabs

[mrogers167]

I am looking to create a master workbook with sub workbooks within the master as tabs. When clicking on each "sub workbook" tab it would still have its own worksheets.
I do not want to embed a workbook link within another workbook.
Is there a code to do this in excel.

Thanks

[nathansav]

Not like you want, you could mimic it, opening all the sub workbooks and hiding them

Please Login or Register  to view this content.

Then you could have a matrix on a hidden sheet, that links the sub books to the main book, or run a parallel collection when defining the sheets. Collections are like arrays, but with a key that cant be duplicated. And you can reference the collection by the key.

So you could have

Please Login or Register  to view this content.

then you could just do

Please Login or Register  to view this content.

I am not in Excel at mo, so this is not tested.