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

GHalleck 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 use the /b switch, dir/b >dir.txt, you will get a bare listing. See if this suits your needs. Type dir /? to see other switches and options.
Dave Cohen
.