VBA Code:
Set closedBook = Workbooks.Open("c:\sourcebook.xlsx")
closedBook.sheets("CopyMe").Copy before :=ThisWorkbook.Sheets("Sheet1")
CopyMe.name = "newName"
I know that I can copy and then rename the sheet in the Target workbook.
My challenge is I already have a workbook with that name. I don't want it to say CopyMe (2) and then have to do a rename.
Is there a way to do a copy and have the name of the sheet be some thing else when it gets added to the target book?
Thanks,
Kevin