MP3 Change Filename

[kindi1000]

I have a macro which changes the names of songs, but it cannot change the names of particular songs because it cannot find them. The reason being - the filename uses a symbol which is not recognized by vb. Is there a way to only search the first 40 characters of a song title and save it by that new name (i.e.: leave only the first 40 characters of the name as the name)? An example of a title is:

003 - Rihanna ft. Jay-Z - Umbrella [Torrent-Tatty] (� IDJMG).MP3

The questionmark symbol shows up as an unidentifiable symbol. There are a lot of spaces in the file name. Thanks.

 

[Oorang]

That's an interesting one, vb should be able to read/write the full unicode set even if excel doesn't display it right. Care to post the macro, might be to just debug it a little.

 

[kindi1000]

Thanks. The macro is as follows:

Sub CopyMP3()
Dim oFileName As Variant
Dim nFileName As Variant
Dim i As Variant

Range("B11").Select
i = 1
Do While ActiveCell.Offset(i, -1).Value <> ""
If ActiveCell.Offset(i, -1).Value <> "" Then
oFileName = ActiveCell.Offset(i, -1).Value
nFileName = ActiveCell.Offset(i, 0).Value
FileCopy oFileName, nFileName
End If

i = i + 1
Loop
End Sub


I basically rename a file based on a new filename, but VB could need read the "?" symbol in the original filename. Thanks.

 

[Norie]

Eh, that's not renaming a file - it's copying a file.

It's probably difficult to pinpoint a particular file without the exact name.

Is there any naming convention for either the old filename or the new filename?

Are all the files in the same directory?

 

[WaxonWaxov]

you may need to look at each character in the string and look at it's ASCII value and change certain one into blanks or underscores or something like that.

 

[kindi1000]

True - but the way I rename is to copy in case I mess something up. There is naming convention, but that is done within Excel - but I think we could probably ignore that for now. All the files are in the same directory. If you think that renaming rather than copying would make my life easier, then I'm all for that. Thanks.

 

[Norie]

Why ignore the naming convention if it might help?

 

[kindi1000]

Ok. The naming convention I use is:

Lets take the following filename:
003 - Rihanna ft. Jay-Z - Umbrella [Torrent-Tatty] (� IDJMG).MP3

I would change it to:
Rihanna ft. Jay-Z - Umbrella.MP3

Thanks.