PC Review


Reply
Thread Tools Rate Thread

Create a filename list from a directory

 
 
sat
Guest
Posts: n/a
 
      22nd Nov 2003
How can I capture the filenames listed in a Windows
Explorer folder in an Excel or a Word document?

Thank you
 
Reply With Quote
 
 
 
 
Austin M. Horst
Guest
Posts: n/a
 
      23rd Nov 2003
Open the command prompt (cmd.exe),
change the directory to a folder of your choice and type
DIR
select the text and copy it into Word or Excel.

Austin M. Horst
 
Reply With Quote
 
somebody@compusmart.ab.ca
Guest
Posts: n/a
 
      23rd Nov 2003
"sat" <(E-Mail Removed)> wrote:

>How can I capture the filenames listed in a Windows
>Explorer folder in an Excel or a Word document?


Great freeware program to that does this and many other things
http://www.karenware.com/powertools/ptdirprn.asp

Roger
 
Reply With Quote
 
R. C. White
Guest
Posts: n/a
 
      24th Nov 2003
Hi, Sat.

Open a "DOS" window and use the Dir or Tree command to produce the list of
filenames onscreen. Combine this with the redirection arrow to send the
list to a text file instead, which can then be opened by other programs,
such as Notepad or Word.

For example:

dir > list.txt

where "list" is any filename you choose.

For a mini-Help file for Dir or Tree or any other DOS command, type the
command followed by /?, such as:

dir /?

Play with these commands until you are comfy with them, then create your
text document and use it as you wish.

There may be better ways, using the GUI, but old DOS hands like me seem to
always find ourselves using the old tricks. ;^}

RC
--
R. C. White, CPA
San Marcos, TX
(E-Mail Removed)
Microsoft Windows MVP

"sat" <(E-Mail Removed)> wrote in message
news:028301c3b152$f6720cd0$(E-Mail Removed)...
> How can I capture the filenames listed in a Windows
> Explorer folder in an Excel or a Word document?
>
> Thank you



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
create directory list JP%$ Microsoft Access 1 7th Nov 2008 05:18 PM
Footer to list Directory & Filename TigerLady Microsoft Excel Discussion 10 25th Jun 2008 08:31 PM
How do i create a list of files per directory? =?Utf-8?B?Q29zdGlz?= Microsoft Excel Programming 4 23rd Apr 2007 12:16 PM
Create and import filename list into excel =?Utf-8?B?SmltIFNlbWFq?= Microsoft Excel Programming 3 12th Dec 2005 06:05 PM
Create a mailing list from a DIRECTORY ! =?Utf-8?B?U3RldmU=?= Microsoft Outlook Discussion 6 3rd Nov 2005 07:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:16 PM.