Automatic List of Files in Directory, using Excel Macro VBA

Description
//The problem it solves
This Excel Macro file is useful if you need to have a list of all the files stored in a certain location (folders) on your computer.
I call it ‘Inventory’ because I use it to generate a list of the files in a folder location. Then I can further use that list in other data manipulation. This VBA macro saves me a lot of time!



//How it works
You need to run the macro command stored within the file. Press [Alt + F8], select *MainList* and then click on Run.
The macro is very simple to run, and it generates a list which can be useful for your projects.
The cover of the file contains the simple instructions to run it, but if you're familiar with running Excel Macros you can go directly to the Inventory spreadsheet.


//Who can use it
Anyone familiar with Microsoft Excel can use this automated file.
I recommend it to people working in Human Resources, Customer Care, and Sales Operations - this can be used to handle multiple letters or template documents that are to be shared with a large audience.