Workbooks in a Directory

Macro 12: Open All Workbooks in a Directory Here’s a scenario: You’ve written a cool macro that applies some automated processing to each work- book you open. Now the problem is that you need to go into your directory, open each workbook, run the macro, save it, close the workbook, and then open the next […]