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???

A macro is the easiest way, if you're OK with that. Post back. If not:

Start - Run. Type "cmd" OK -- should open a command window
Navigate to the folder you want using CD commands
use CD.. to back up a folder
Type DIR. You should get a list of the files and folders in the folder
you're in.
Click the System Button (in in the upper left corner of the command window)
Click Edit - Mark
Drag through the stuff you want (just the file names at right). Press Enter
(does a Copy)
Switch to Excel and paste.

Alternatively, use
DIR DIRLIST.TXT

Now open DIRLIST.TXT in Excel. It should invoke the text import wizard, and
you'll have control over how stuff is put into the sheet.

This whole thing will take some patience and experimenting.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Jason" wrote in message
...
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???