Thread: Can we copy a sheet from workbook1 to workbook2 with out open workbook1?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Can we copy a sheet from workbook1 to workbook2 with out open workbook1?
Lee,

Both workbooks must be open to copy a sheet from one to the
other.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Lee" wrote in message
...
Can we copy a sheet from workbook1 to workbook2 with out
open workbook1? How to do this. Thanks
Have a great weekend.
Lee


Reply With QuoteReply With Quote