PPRuNe Forums

PPRuNe Forums (https://www.pprune.org/)
-   Computer/Internet Issues & Troubleshooting (https://www.pprune.org/computer-internet-issues-troubleshooting-46/)
-   -   Copying filenames into a table (https://www.pprune.org/computer-internet-issues-troubleshooting/377144-copying-filenames-into-table.html)

cargosales 9th June 2009 23:05

Copying filenames into a table
 
I'm sure this, or something like it has been asked recently but I can't find the relevant thread so apologies if this has already been covered.

It's about time I got round to sorting out all the zillions of photos and video clips I've got and to work out how to catalogue / tag them.

My smartarse other half is running Vista on her little used, leisure-use-only machine and has glibly pointed out how easy it is to tag all her photos, whereas I'm running XP on my almost-exclusively-for-business machine and have absolutely no intention of downgrading to Vista.

Does anyone know how I can copy all the filenames in any given folder and paste them as text in Word/Excel/Access, and thence add the tags I'd like to ? Ideally I'd like to include a thumbnail and/or a shortcut in the table as well but I guess that might be asking too much?

Any ideas please folks?

Thanks in advance

CS

GrumpyOldFart 9th June 2009 23:37

I think this will do what you want.

stagger 9th June 2009 23:40

Something like Directory Lister will do it...

Print File List with Directory Lister Pro

Or just bring up a command prompt for the folder - use the DIR command to generate file list and manual copy it into excel (which should parse the columns).

srobarts 10th June 2009 00:03


Or just bring up a command prompt for the folder - use the DIR command to generate file list and manual copy it into excel (which should parse the columns).
I guess I am showing my age as I started in PCs with Dos 1.1 and always go to DOS for a solution first...
There is a DOS command that will write the directory to a text file.
dir /b > directory.txt

this saves the cutting and pasting

This article Print a list of directory contents in Windows 2000 with DOS gives you more info and the switches you can use to alter the output.
Have fun

bnt 10th June 2009 23:46

Dang - you beat me to dir <path> /b > directory.txt - though I would add /s if the directory has multiple subdirectories.

Saab Dastard 11th June 2009 00:08

Copy your files to the Vista PC if it's so easy.

You'll even get a free backup thrown in for no extra effort! :ok:

SD


All times are GMT. The time now is 13:30.


Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.