Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
Member Login
Site Notices
1/25/2018 7:38:29 AM
Posted: 8/5/2002 2:40:28 PM EST
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?
Link Posted: 8/5/2002 3:10:28 PM EST
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
Link Posted: 8/5/2002 3:13:55 PM EST
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
Link Posted: 8/5/2002 3:14:03 PM EST
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.
Link Posted: 8/5/2002 3:17:42 PM EST
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]
Link Posted: 8/5/2002 3:32:57 PM EST
[Last Edit: 8/5/2002 3:33:36 PM EST by The_Macallan]
Thanks [b]Hmanjr[/b] and [b]misterH[/b], I'll try it. Damn I LOVE this board!!
Link Posted: 8/5/2002 7:38:36 PM EST
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!!
Link Posted: 8/5/2002 9:17:41 PM EST
Yeah but ya'lways come through no matter what the question! It worked, thanks again guys.
Link Posted: 8/5/2002 9:20:14 PM EST
[Last Edit: 8/5/2002 9:20:41 PM EST by prk]
Wait till he gets that phone call and realizes what those commands REALLY did.....[:D]
Top Top