Check out this tutorial 153486. It deals with Excel and Win32::OLE.

I think you may need to use the SheetActivate to provide the correct focus in the excel book, before you add it to the second book.