Copying a list of files into Word - Windows XP
Copying a list of files into Word - Windows XP
Author
Discussion

Jasandjules

Original Poster:

72,695 posts

260 months

Sunday 29th July 2007
quotequote all
Hi,

Can this be done?

I have a directory with a huge list of files, now I want to copy them into Word or Excel so I can add comments alongside each one and record what I have. BUT I can't find a way of copying the entire list in one swoop, I have to open the properties of each file and copy the name, then paste that into Word/Excel.

Is there an easy way to do this please? Would save me ages.


dilbert

7,741 posts

262 months

Sunday 29th July 2007
quotequote all
Get a command prompt up (select run from the start menu, and type cmd), change to the directory you want to list. Type;

dir > filename.txt

Then navigate to the directory/folder with excel, and open the file filename.txt

Specify delimited, and set the delimiter to space.

Edited by dilbert on Sunday 29th July 10:14

Jasandjules

Original Poster:

72,695 posts

260 months

Sunday 29th July 2007
quotequote all
You are a star, that has worked superbly.

Virtual pint to you.

Thanks,

Jas