Hi all,

I would like my VB program to open two Excel workbooks and copy the sheets from workbook1 to workbook2. Is there a way to do this?

I tried to the Copy method, and Save, Add. But they do not work.
All seem to point to working with one workbook only.

I apologise if this query has already been answered, but I could not find any threads that could help.

Many thanks for your time.