Excel-work-with-workbook
work with multiple excel workbooks
- extract all to same folder i.e. c:\temp\
- run program in "How-to-Work-with-Multiple-workbook.xlsm" it has only one macro procedure
in the last procedure input box asking for "YES" upper capital letter for close all workbook which open except current workbook.