Introduction

VBA can be used for a whole host of issues you may encounter in your day to day. VBA is built into Excel which comes as standard with most employers, especially in the world of accountancy. This is the main reason why it was my first point of call when entering the world of coding.

download workbook

Findings

Every time we hit a new year or even a new month at work, I had to make sure to set up the same directories in the same way, with the exact same names, so as not to break any hyperlinks or other macros.

Of course, I could have just taken a template folder but there is a better way to do this! With the template method each core directory file still needs to be renamed to differentiate itself from the other template folder you have pasted in. VBA offers us the ability to create files with the change of one cell value.