Copy worksheet from another workbook

[hashim217]

Hi all,

I need some code that will copy a worksheet named "controller" from an open workbook that is also named "controller" and paste it into the active workbook. I would like there to be a dialog box asking what to name the worksheet once it has been pasted, however, this is not necessary. I have searched online and could not find exactly what I was looking for. If someone can point me in the right direction it would be greatly appreciated. Thanks.

-Hash

 

[VoG]

Maybe like this

Sub test()
Workbooks("controller.xls").Sheets("Contoller").Copy Destination:=ActiveWorkbook
End Sub