Copying worksheets
 

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

Copying worksheets
 

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