You can copy the cell values but not the complete sheet
See my site for a few examples
http://www.rondebruin.nl/copy7.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ups.com...
Is it possible to copy a sheet from a workbook that is not open and
then paste it into the active workbook? I haven't found a way to be
able to do this.