What does Workbook.Copy() do?


I tried to read the docs:
Workbook.Copy Method

But I am not quite sure what it is supposed to actually do?

I tried it with two workbooks, and it seems to have simply replaced the original Workbook with the other one?
I was hoping it to copy the all Worksheets from one Workbook to the other.


Well, Workbook.Copy() method copies other workbook (with its worksheets) to it.

By the way, you may try to merge workbooks if it suits your needs well, see the document for your reference:

Let us know if you still have any issue.

Thank you.