View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Copying sheets form other workbooks

Good morning all,
I have 5 to 8 workbooks in a folder called Class. The workbooks will not
always have the same name but they will only contain one sheet in each book.
I would like to copy that sheet from each workbook into the current workbook.
Is there a way to copy all sheets from all workbooks from a folder such as
c:\class.