Copy a list of filenames for spreadsheet editing 1

[Johnnybundles]

Here's an interesting one! (if you're sad like me)
Not Vista specific, but it's what I'm using.

I have a list of image files in a folder, 150 odd.
I would like to copy the file names and put them into an excel spreadsheet.

Can anyone suggest a way of doing this?
(Other than the PAINFULLY slow way I now do it. highlight the filename hit F2, Ctrl+A, Ctrl+C Ctlr+V into document.)

Any useful suggestions gratefully received.
Johnny.

 

[vacunita]

Use a batch file.

Copy the following into notepad, and save it as filename.bat into the directory you want the list from.

Then just double click the icon to have it run.

@ ECHO OFF
dir /b > list.csv
start list.csv

Provided csv files are associated with Excel, it should work.





----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[Johnnybundles]

WOW!
Thank you - most helpful and a very fast response.

Would you care to explain the commmands? I know they are DOS, but that's about it.

Cheers Johnny.

 

[JPaules]

Even faster - download ASAP Utilities add-in. There is a built-in command that wil do exactly what you want. AND put it in a spreadsheet for you.

--
JP

 

[vacunita]

I could have sworn I answered your question, o.k well here it is again:

@ ECHO OFF [green]Disables output to the screen[/green]

dir /b > list.csv [green]dir lists the contents of a given directory, and the /b switch makes it so t just lists names without any additional information.  It then sends it all to a file: list.csv[/green]

start list.csv [green]Opens the created file. As long as CSV files are associated with Excel, which by default they are, it will open excel and show the file. [/green]

Of course you could instead of opening the file with the start command, call excel explicitly and pass the file name to it.




----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[Johnnybundles]

Thank you again,
That is most helpful. It's something that has been a problem to me for a while, unfortunately I need to copy lists of file names quite oftern. & I don't know enough about DOS to have created anything like this.
Regards Johnny

 

[vacunita]

Glad I could help.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[JPaules]

Johnny -

Try the add-in ASAP Utilities. I'm not kidding you when I tell you it has to be the most awesome add-in I have ever seen. (No, I'm not the developer or related to the duy who is.)

No DOS neded, no copying and pasting, it's almost idiot-proof. (I have to say almost because there is always someone out there who can prove me wrong.)

--
JP