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.
|