Help...Code to copy sheet from closed workbook

[dswiders]

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.

 

[Ron de Bruin]

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