Path | # of files in folder/subfolders |
Z:\Windows\User | 139 |
Z:\System\files | 1213 |
Z:\Windows\Temp | 5600 |
Z:\Data\user\jamie\files | 125 |
<tbody>
</tbody>
Can someone help me with some VBA code that will read down through Column A and starting at the path in that cell, get a count of all files and sub-folders under the path and report that number in Column B?
Thank you in advance for any help on this!