Open an other workbook, use the copy method to copy the sheet(s) to
the new workbook, close the other workbook without saving it.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Jonathan"
wrote in message
Hello,
I created a new workbook and I want to copy worksheets from several other
workbooks into it. How could this be done. Any help greatly appreciated. (I'm
doing this from an external VB6 program).
Jonathan