khaledocom
03-16-2011, 03:40 AM
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.
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.