File Transfer

[gibsonsgman]

Hello, I am making a music database. Right now i have all of my music
files in one folder and what i want to do is find a function that will
search through all of these files and look at their artist and then
move them to the folder corresponding to the artist. any ideas?

 

[John Nurick]

I haven't tried it myself, but
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=1&txtCodeId=5533
might be the ticket, at least as concerns extracting artist information
from the file properties. If it works in VB5 and VB6 it should take
little effort to adapt it to VBA.

For the rest of the process, I'd set up a table with fields for the
artist's name and the folder, with multiple records to cover variations
of the artist name: e.g.

Folder Artist
Schwarzkopf Elisabeth Schwarzkopf
Schwarzkopf Schwarzkopf, Elisabeth
Schwarzkopf Schwarzkopf, E

After that, it's just a matter of iterating through all the files. For
each file, the process might be:
Extract artist information
Look it up in the table
If a matching record is found
move the file to the corresponding folder
Else
add the artist to a list of "unmatched names"
so the user can create appropriate folders later
Loop to next file