How can I quickly copy the names of all of the files in a folder (in Windows) into a list for a spreadsheet like Excel?

Is that possible?

Don't think it is posible.  You can try selecting them all, post them onto Notepad, and them import them onto the excel.  Might work.

Sgtar15

Don't believe it is possible. They won't line up the same way. I think you will have to hand jam them in...

C4

Yep it's possible. It sounds worse than it actually is. Do it once and you'll be an old pro.

Do you know how to get to a command line?
- hit the start button
- hit the run button
- type in command (if you have window 95 or 98)
- type in cmd (if you have windows nt or 2000)

Do you know which directory you want to list.

Can you use the cd (change directory) command? Use it to navigate to your directory.
-
- it'll look like
   c:    c:\[b]cd my_files[/b]
   c:\my_files
Use the dir command to list your files.
- c:\my_files\[b]dir /b[/b]
   the /b switch will list only file names.

redirect the dir listing to a text file.
- it'll look like
  c:\my_directory\[b]dir /b > Fred.txt[/b]
    the > tells the computer to redirect the output from the screen to the text file you specify, in this case I called it Fred.txt. You can name it whatever you want, though it might be best to stick with less than 8 characters.

Then open up excel and import the text file. The specific version of excel will determine where the import text button/ command is at. Excel 2000 it's under the data/ get external data/ import text file.

Hope this helps. I'll keep looking for follow up questions for a little while.

If you can import a text file I can tell you how to make a text file of all of the files in a folder (in Windows).

1) Go to a command prompt

2) type: "[b]dir \[/b]the_path_to_the_folder \*.* [b]/s >[/b] some_file.txt"

(without the quotation marks)

e.g.- [b]dir \winnt\profiles\johndoe\porn_folder\*.* /s > boss_spies_on_you.txt[/b]

Thanks [b]Hmanjr[/b] and [b]misterH[/b], I'll try it.



Damn I LOVE this board!!

God we are a gullible bunch.

He insults us with topic title "question for computer geeks... uh - nerds... er, uh "users""

And we still answer him!!!

You're right, Damn I LOVE this board!!

Yeah but ya'lways come through no matter what the question!

It worked, thanks again guys.

Wait till he gets that phone call and realizes what those commands REALLY did.....[:D]