Any way to copy file names in windows explorer & paste into Excel?
Are you familiar with using the command prompt (DOS commands)?
You can copy the contents of a directory (folder) into a text file and then
open that text file in Excel.
Goto Windows Start buttonRun
Type CMD in the box and hit enter
This is where using short reasonable paths comes in handy!
Type in this command:
DIR [path to your music files] mymusic.txt
In my case this would be:
DIR C:\TV mymusic.txt
hit ENTER
Close the command prompt window. Either click the "X" or type in EXIT.
Then you can open the file mymusic.txt in Excel.
Biff
"Jason" wrote in message
...
Here's what I'm trying to do. For some reason I'm having trouble getting
music to copy into my itunes library. I have all of the music files in a
separate folder & it seems like approx 3/4 of them are copying to the
library. There are about 10,000 songs total, so it's not practical to go
through them manually.
I am able to copy from itunes & do a "paste special" into excel & paste
the
file names as text. I'm trying to do something similar in windows
explorer
so that I can do a compare to find duplicates & see which files are not
copying.
Is this possible? I know what i need to do in Excel, I just can't seem to
get the file names INTO Excel.
|