Copy a worksheet from one workbook to another, select menu required

Hi everyone,

I am pretty new to VBA Excel but I was hoping someone could help me on this task, it's been driving me nuts.

I have scowered the net looking for a solution but cannot exactly locate the optimal solution. I've found many in the net which offers VBA codes for copying a sheet from one workbook to another but in those you need to specify the file path in the coding.

My dilemma is that this model will be used for various different workbooks, therefore specifying a file path in the coding will not be friendly to the users I hand it too who require full-automation (not having to look at coding!). I am looking for a file select menu which will allow the user to select the workbook and worksheet to copy. I don't need a file select menu to paste the copied worksheet because it will always go into the same worksheet. The copy phase of the code will need a file select menu but the paste code can be defined in the VBA code itself.


Thank you in advance.

Enan H.

Hi,


I've found many in the net which offers VBA codes for copying a sheet from one workbook to another but in those you need to specify the file path in the coding.


It sounds like you have the Workbook copy under control. Now you need a File Browser to select the files you want.

Have a look into msoFileDialogFilePicker. The user can navigate to the desired directory and tag as many files as they wish. Also, there are many parameters you can change i.e. AllowMultiSelect, InitialFilename etc..


I hope this gets you started.