I've got a macro which I use at least 43 times a month and I'm
wondering what would be the best way to automate it.
Currently, I'm opening up each workbook manually, running the macro
which does something, saves the document and closes it. The only
manual part is to open the workbook.

Each month, these workbooks are located in a different folder (eg: for
month) and I'm wondering what the best way to automate the "open
workbook, call existing macro" for each workbook in a target folder.
When the macro runs for the first time it would prompt the user for
the 'target' folder and off it runs.