Hi all,
Is it possible to have a code that extracts the contents of My documents and desktop to one sheet as follows:
My documents
Subfolder-1
files ..
files ....
Subfolder-2
files ..
files ....
So on ..................
Then desktop contents as well.
After finish listing, save the worksheet in same excel file.
Please help.
Thanks in advance.