shragi
asked on
Get filename and folder into excel
Hi - I want to pull all the path and file names for a set of directories and then I want to dump them into excel.
So if I give a subdirectory name it command line script should pull all the filename and their path into the excel.
The attached image contains an example of what I am looking for - the image is for subdirectory1.
Thanks,
excel.PNG
So if I give a subdirectory name it command line script should pull all the filename and their path into the excel.
The attached image contains an example of what I am looking for - the image is for subdirectory1.
Thanks,
excel.PNG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That is a VBS script. You can run it from a command line (or from a BAT file) like this:
cscript EE28929958.vbs
Where EE28929958.vbs is the name of the file you save the code as. Also notice that in that script code is the name of the base folder to report on, so edit that before running.
~bp
cscript EE28929958.vbs
Where EE28929958.vbs is the name of the file you save the code as. Also notice that in that script code is the name of the base folder to report on, so edit that before running.
~bp
I see you deleted your last comment. Let me know what questions you have or changes you might need.
~bp
~bp
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Bill and Bill.
I had some issues but made changes using your input.
I had some issues but made changes using your input.
Thank you shragi
ASKER