Any way to copy file names in windows explorer & paste into Excel?
 

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.

Any way to copy file names in windows explorer & paste into Excel?
 

Jason

Several methods to accomplish this.......I like Tushar's best if importing to
Excel.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default...EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom
features.

OR Go to DOS(Command) prompt and directory.
Type DIR MYFILES.TXT

All the above create a *.TXT file which can be opened in Notepad or
Excel.

One more method if you want to by-pass the *.TXT file and pull
directly to Excel is to use Tushar Mehta's Excel Add-in. This allows filtering
and sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-insDirectory
Listing.

Download the ZIP file and un-zip to your Office\Library folder.


Gord Dibben MS Excel MVP

On Mon, 15 Jan 2007 11:08:01 -0800, Jason
wrote:

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.

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.

Any way to copy file names in windows explorer & paste into Excel?
 

There's a program at Debra Dalgleish's site that creates .M3U files (playlists).

It searches a specified folder for .mp3 and .wma files--but you could modify the
code to retrieve more file types. And it writes the file names to a worksheet
in a new folder.

You could delete this line:
wks.Parent.Close savechanges:=False
so that that temporary workbook is not closed--then you could what ever you
want.

The purpose of the workbook (From Debra's site):

UF0005 - Music Playlist Creator -- Click a button, and the code in this file
creates a playlist of music from a selected folder, and places it on your
desktop for easy access

I'm not sure how iTunes works, but you can always delete that folder on the
desktop if it doesn't work.

On Debra's site:
http://contextures.com/excelfiles.html
look for:
Music Playlist Creator

Jason wrote:

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.

--

Dave Peterson