Fast Tip Friday – The Art of Rubber Banding

This fast tip demonstrates how to use an Excel VBA macro to generate a folder listing in Excel. In a previous Fast Tip Friday tutorial, I demonstrated how to get a list of all files in a folder using an Excel macro. Download Sample Files

Have you ever needed to add the same subfolder to a bunch of existing folders? For instance, let’s say you have a list of folders that are named by custodian and you need to add an Exhibits subfolder to each and every custodian folder. This fast tip demonstrates how to automate the task using an…