I would like to print out a list of all the files in some of my
document directories e.g. All the songs in My Music.
Is it possible to copy the contents of a directory into a worksheet for
editing and printing?
If not, does anyone know of any software that will do the job for me?
TiaThis is a link to a similar discussion from last summer:
groups.google.com/group/micro...f917eac 4be8fHere is one way tinyurl.com/8l2z2
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Bampahquot; gt; wrote in message oups.com...
gt; I would like to print out a list of all the files in some of my
gt; document directories e.g. All the songs in My Music.
gt; Is it possible to copy the contents of a directory into a worksheet for
gt; editing and printing?
gt; If not, does anyone know of any software that will do the job for me?
gt; Tia
gt;
quot;Bampahquot; gt; wrote in message oups.com...
gt; I would like to print out a list of all the files in some of my
gt; document directories e.g. All the songs in My Music.
gt; Is it possible to copy the contents of a directory into a worksheet for
gt; editing and printing?
gt; If not, does anyone know of any software that will do the job for me?
gt; Tia
gt;
This is one of those simple dos jobs Explorer makes difficult -- redirect
the file directory to a text file then open it in Excel for whatever further
processing you want.
[start], [run] to bring up the windows run box
command [enter] for a dos prompt
cd quot;c:\my documents\my musicquot; (or wherever your subdirectory is; need
quot; if there are spaces)
dir *.* gt; filelisting.txt
exit (to close dos window)
star Excel and open open c:\my documents\my music\filelist.txt for whatever
further processing you want
Thanks guys. I went with Jim Cone's 'List Files' add-in and it does the
job perfectly.
- Apr 13 Sun 2008 20:43
Directory listing
close
全站熱搜
留言列表
發表留言