- Open all workbooks in a specific folder one at a time
- Save each sheet in each workbook as a separate file to a separate directory
- The names equal the worksheet names themselves plus a unique counter added to the end
(e.g. Sheet1-0001.xls, Sheet2-0002.xls, etc.)
- Do NOT save the last sheet in the workbook...save all others
- NOTE: The SaveAs command for Excel 2007+ is more detailed. Choose the correct SaveAs command for your version of Excel.
Nothing says "thanks" like a steak dinner!