Listing folder names in a column
Hello everyone, I am very new to VBA! I work in tech-support at a local company, and today I've gotten an assignment that feels like it would take ages to do manually. Basically, I am to list a bunch of folders (1,001 to be exact) along with their size in megabytes and a boolean variable indicating whether or not the folder has a relevant user in AD. The last part probably has to be done manually, but I feel like there is probably some very simple script to automate the first two requirements. The format should be like this: Column A (Name) lists the name of each folder (they are all in the same directory) and column B lists the size in MB of that folder. The only programming I know is in C++, so any help to get this to work would be greatly appreciated.