SOLVED

I want to house multiple Workbooks in one Workbook. Is this possible?

%3CLINGO-SUB%20id%3D%22lingo-sub-2007468%22%20slang%3D%22en-US%22%3EI%20want%20to%20house%20multiple%20Workbooks%20in%20one%20Workbook.%20Is%20this%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2007468%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20GUI%20interface%20like%20the%20one%20described%20in%20this%20link.%3C%2FP%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.instructables.com%2FMake-your-own-GUIgraphical-user-interface-in-Micro%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.instructables.com%2FMake-your-own-GUIgraphical-user-interface-in-Micro%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20GUI%20will%20have%20a%20selector%20in%20which%20person%20can%20select%20an%20individual%20workbook.%20I%20can%20use%20links%20to%20file%20on%20sharepoint%20but%20I%20rather%20house%20them%20in%20the%20one%20workbook%20that%20the%20GUI%20is%20housed%20in.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2007468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2007611%22%20slang%3D%22en-US%22%3ERe%3A%20I%20want%20to%20house%20multiple%20Workbooks%20in%20one%20Workbook.%20Is%20this%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2007611%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F908730%22%20target%3D%22_blank%22%3E%40Robb0912%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20store%20multiple%20%3CEM%3Eworksheets%3C%2FEM%3E%20in%20a%20single%20workbook.%20It%20is%20very%20well%20possible%20to%20let%20the%20user%20select%20a%20worksheet%20from%20a%20combo%20box%20or%20list%20box%20on%20a%20userform.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStoring%20multiple%20%3CEM%3Eworkbooks%3C%2FEM%3E%20in%20a%20single%20workbook%20makes%20no%20sense.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2007637%22%20slang%3D%22en-US%22%3ERe%3A%20I%20want%20to%20house%20multiple%20Workbooks%20in%20one%20Workbook.%20Is%20this%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2007637%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BEach%20workbook%20has%20alot%20of%20tabs%20for%20project%20management.%20Thats%20why%20it%20would%20make%20sense.%20Like%20a%20Workbook%20Manager%20of%20sorts.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2007743%22%20slang%3D%22en-US%22%3ERe%3A%20I%20want%20to%20house%20multiple%20Workbooks%20in%20one%20Workbook.%20Is%20this%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2007743%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F908730%22%20target%3D%22_blank%22%3E%40Robb0912%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou'd%20either%20have%20to%20link%20to%20the%20separate%20workbooks%2C%20or%20move%20all%20the%20sheets%20from%20all%20the%20workbooks%20into%20the%20workbook%20with%20the%20userform.%20Excel%20does%20not%20have%20the%20concept%20of%20a%20%22workbook%20of%20workbooks%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I want to create GUI interface like the one described in this link.

 https://www.instructables.com/Make-your-own-GUIgraphical-user-interface-in-Micro/

 

That GUI will have a selector in which person can select an individual workbook. I can use links to file on sharepoint but I rather house them in the one workbook that the GUI is housed in. 

4 Replies

@Robb0912 

You can store multiple worksheets in a single workbook. It is very well possible to let the user select a worksheet from a combo box or list box on a userform.

 

Storing multiple workbooks in a single workbook makes no sense.

@Hans Vogelaar Each workbook has alot of tabs for project management. Thats why it would make sense. Like a Workbook Manager of sorts. 

Best Response confirmed by Robb0912 (New Contributor)
Solution

@Robb0912 

You'd either have to link to the separate workbooks, or move all the sheets from all the workbooks into the workbook with the userform. Excel does not have the concept of a "workbook of workbooks".

@Hans Vogelaar Thanks you saved me a lot time on deciding my direction