ID3v1 теги в mp3 файлах, получить всю информацию о треке на VBA
Sub CreateReport_Mp3FileProperties()
Dim iFileName$, iPath$, iRow&, iColumn&
Dim iFolder As Object, iMp3File As Object
iPath = "B:\Muzic Hits\": iRow = 2
Set iFolder = CreateObject("Shell.Application").Namespace(CVar(iPath))
If Not iFolder Is Nothing Then
iFileName = Dir(iPath & "*.mp3")
If iFileName <> "" Then
Workbooks.Add xlWBATWorksheet
Application.ScreenUpdating = False
Do
Application.StatusBar = iFileName
Set iMp3File = iFolder.ParseName(iFileName)
For iColumn = 0 To 50 '
Cells(iRow, iColumn + 1) = iFolder.GetDetailsOf(iMp3File, iColumn)
Next
iFileName = Dir
iRow = iRow + 1
Loop While iFileName <> ""
For iColumn = 0 To 50 ' Headers Report
Cells(1, iColumn + 1) = iFolder.GetDetailsOf(iFolder.Items, iColumn)
Next
Application.StatusBar = False
Application.ScreenUpdating = True
Else
MsgBox "No files .mp3", , ""
End If
Else
MsgBox "Folder is not found", , ""
End If
End Sub
Комментариев нет:
Отправить комментарий