Link to home
Start Free TrialLog in
Avatar of shragi
shragiFlag for India

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
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of shragi

ASKER

Thanks Bill - is this a batch script ?
Avatar of Bill Prew
Bill Prew

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
I see you deleted your last comment.  Let me know what questions you have or changes you might need.

~bp
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of shragi

ASKER

Thanks Bill and Bill.
I had some issues but made changes using your input.
Thank you shragi