Re: How can I copy and paste a directory listing into Excel

Thanks guys for all your help.

I’m partly there. I did download the “CmdHerePowertoy” application and used
it to open the “Command Prompt” window with the correct directory path. But
I’m stuck after Trev’s instruction to use the b switch, that is after typing
“dir/b>filelist.txt”. What do I have to do to open the listing after that?

Please note that I don’t know MS-DOS.


"Trevor" wrote:

On Sat, 21 Oct 2006 10:46:21 -0700, GHalleck
<ghalleck@xxxxxxxxxxxxxxxxxxx> wrote:


Felix wrote:

I know how to print a “Directory Listing” but instead I would like to copy
and paste it into Excel. All I want from the listing are the files’ name.
Right now I print the listing and key in the name of the files in a
spread***. This is very time consuming and subject to errors.

Can I copy the "Directory Listing" and paste it into an Excel spread***?
If so how?

I am using Windows XP SP 2 Home

Thank you.


This is one method. From the Command Prompt, go to the folder
or directory. Type DIR and re-direct its output to a *.TXT
file, e.g., dir >mylistings.txt. Start Excel, locate this
text file and open it. All of the DIR information should show
up in columnar form. Some parsing may be necessary.

If you go here:
http://download.microsoft.com/download/whistler/Install/2/WXP/EN-US/CmdHerePowertoySetup.exe

download then install.

then when you are in explore you can right click the directory and
choose "Open command window here".

then use the following for only the filenames. By using the /b switch
it uses the bare format of file lists.

dir /b > filelist.txt

Then as mentioned above you can either cut and paste the list or
import it.

There may be some free utilities out there to simplify this but
perhaps others can direct you to those. These steps are certainly less
labor intensive then hand typing them in from scratch. lol

Good Luck,

Trev

.

Quantcast