View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason Jason is offline
external usenet poster
 
Posts: 367
Default convert files to text

This issue is related to music. I am having trouble adding folders to a
library--roughly 1/2-3/4 of the files are importing. Because of the numbers
(8000+ songs) it's not practical to go through them manually to find the
tracks that did not import properly.

I want to create 2 sheets--one with the tracks in my music library, the
other with the files in the folder that it's importing from..so I can find
duplicates & see the records that did not import.

Now (finally) to the question--is there a way to take all of the files in
windows explorer & convert the file names to text so that I can paste them
into Excel? I tried to copy & "paste special" as text, but it doesn't work.

Any ideas???