Copy sheet from active/open workbook to other closed workbook.

[i200yrs]

Hello All...please someone help a VBA code that can automate copy of sheet from open workbook and paste to other but closed workbook.
Then overwrite if sheet name exist. Example as follows:
Open File1 = main file, have the sheet name "report". Consist macro that copy the sheet name "report" to other closed workbook.
Closed File2 = a closed file, i want to paste here the "report" sheet name.

 

[Herakles]

The workbook that you are copying to will need to be opened to copy the sheet.

This can be hidden from the user.