Question: how to copy one sheet to another workbook in excel vba?
Answer: C:\Users\XXX\Documents\Target_Book. xlsx should be changed to the actual path and name of the workbook from which you want to copy a sheet.
Sheet1 should be replaced with the name of the sheet you want to copy.