Here you can,
Perform several actions on your WorkBook called “Workbook”. To make this easier, the Sheet that contains most of your data will now be called the “Database”,
Hide the current WorkBook and show the form,
Open a WorkBook that is in the current File,
Open a WorkBook that is in another File,
Save and Close the currently active WorkBook,
Close all workbooks that are currently inactive.
Simply insert the requested value in the box, click on the “Get code” button and Hop, the code appears in the square at the very bottom of the page… copy it and paste it into your UserForm…That’s it 🙂