Community archive

Ask something
Discussion Locked

Print Directory script

0 helpful
1 reply

by ben a

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello all...

I downloaded the Print Directory vbs abd accompanying bat file found here https://www.techrepublic.com.com/5129-6240-1761.html today, but I have to confess I'm not real clear how to use this.

I downloaded the zip file to a particular directory on my file system that has no assoicated sub-directories. When I run the batch file all I get is a print-out of the 2 files contained in the "working" directory.

How can I get this process to run through ALL my directories, beginning with "root" ("C" in this case? Also, how can I modify the vb so that it does not print nor quit Excel? I would rather it just leave the Excel window active so I can refer to it, save it, print it, etc.

Thanks for any help anyone can offer!

1 reply

by wordworker

I couldn't get it to work the way I wanted either.

I used dir *.* /s > target.txt

to capture in target.txt all all files in all directories and subs. You may want to add /b if you want just the 'basic' info returned by DIR. Then you can open target.txt in Excel and the text-to-columns wizard will let you parse it the way you want it.

This discussion is closed to new replies.