From excel VBA, how would I run the command prompt:
dir /a /s /b > FileList.xls
It should accept a directory variable from 'MSO Folder Picker', so that the user may select a directory to spill the contents onto a worksheet in the active workbook.
I have found several instances of VBA to execute similar functions, however, the command prompt outputs exactly the desired results. Rather elegantly, I might add.
