This video will outline an approach to open, edit and close multiple workbooks in a selected folder. There are example financial data for businesses in four workbooks - US, UK, European and Asian subsidiaries.

We want a macro to open each workbook, and make some uniform changes to the first four sheets in each workbook.

Clearly this will save time and improve accuracy compared to doing it manually. Even more so, if there were more workbooks than in this example.

свернуть