Copying a sheet from another workbook into open workbook

[ScabbyDog]

I have the below code which copies a sheet called "TestSheet" from another workbook I specify into the workbook where I run the macro onto sheet "CopiedSheet".

However, if the sheet on the other workbook is called something else other than TestSheet it does not work. There is only one worksheet in the other workbook so how do I alter the code to make it work?

Please Login or Register  to view this content.

[davesexcel]

Change,

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Or it may even work without the sheet designation since there is only one sheet anyway.

[ScabbyDog]

Thanks! Works great.

One other thing, instead of opening a dialog box to select the file, is there anyway I can have it so that the user can drag the file into a certain cell and that prompts the macro to run on that file?