Copy worksheet from another closed workbook using VBA/userform

[jd0219]

Hi guys,

I recently started studying macro a week ago. Im trying to copy worksheet from a specific workbook to my main workbook. Currently i have 3 separate workbook where I copy the worksheet. Is there a way I can use a userform(a list box) to select a specific workbook?


Any help would be appreciated.
Thanks in advance

 

[My Aswer Is This]

I will need to ask several questions.
1. Do you know how to load your three workbook names into a Userform Listbox?
2. We would need to know all three workbook names
3. We need to know the name of the sheet to copy and where exactly to paste it.
like paste after sheet(3)
4. We would need to know the name of the UserForm Listbox
5. We need to know the Path to the 3 Workbooks. To Open them if their not already Opened.
6. And the Workbooks would have to be open or the script would have to Open the Workbook.
See we always need specific details
Your script would need to look something like this:

Private Sub CommandButton5_Click()
'Modified  4/24/2019  1:12:55 PM  EDT
Workbooks(ListBox1.Value).Sheets(1).Copy After:=Sheets(1)
ActiveSheet.Name = "My Copy"

Again this would depend on a lot of factors like I mentioned above.