Import Specific Sheet into Workbook with VBA

Hi all,

I am working creating an excel tool, and part of it involves importing a sheet from one workbook into another. However, I want it to be dynamic so that the name of the sheet doesn't have to be the same.

Right now I have the following code that imports the sheet named "Import"

Please Login or Register  to view this content.

Is there a way to display what sheet names exist within the workbook that you want to import from, and then allow the user to select which they would like? (As is possible when importing excel data into access)

Any help or suggestions would be appreciated, thanks!

Hi chicagoland8

Add a UserForm with a ListBox to Wb1. Place this Code in the UserForm Code Module

Please Login or Register  to view this content.

Replace your "Import" Code with this

Please Login or Register  to view this content.

Sample attached...

Hi Chicago

Sure, add an import Button to the UserForm. Your UserForm Code will look something like this

Please Login or Register  to view this content.

I'd recommend you do some error checking to make certain a Worksheet was selected from the ListBox.

You're welcome...glad I could help. Thanks for the Rep.