Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[heretic]

i wanna get a list of just file names from a folder, so i can take it and apply it to an excel document.

i can't for the life of me figure out how to do this though, and you guys seemed where to turn.
i know i'll be kicking myself for not thinking of it, but your help would be greatly appreciated

[5thWheel]

bring up a dos prompt (Choose Start, Programs (All Programs in XP), Accessories, Command Prompt to open such a window) and do
dir /b
in the folder you want a listing from.

(you use
cd C:\Documents and Settings\Administrator
or whatever folder you want instead of "C:\Documents and Settings\Administrator" to change to to change the current dos folder - but you probably know this!)

you can do
dir /b >foo.txt
to put the directory listing into a file if you want

dir /? for other things that dir can do (like 8.3 filenames)

Hope I understood what you were asking and apologies if you already knew/ have tried this

[jhocking]

When you say "wanna get a list," what do you mean?  Do you mean you want the onscreen display to be a list of filenames, or that you want the file list written to a text file or something?

[heretic]

text file, please

[5thWheel]

what i said then
(edit: oops, unless you want to get the list from within excel, i.e., using VB or something?)

[nihilist]

So many ways of doing that.  All depends on the level of technical prowess present, and the elegance desired.