Meta data of mp3 and wav files to Excel

[TimvMechelen]

Hi all,
Is it possible to get all meta data of mp3 and wav files into excel of a specific folder?
I need the data: filename, artists, song title, bpm, genre, album and key of the song.

Thank you in advance.

 

[Domenic]

The following macro assumes that the specified folder exists, and that a workbook is active. It creates a new worksheet within the active workbook, and places the results in that worksheet starting at cell A1. Here's the code...

Option Explicit

Sub GetMetaDataFromSoundFiles()


    Dim objShellApp As Object
    Dim objFolder As Object
    Dim varColumns As Variant
    Dim arrData() As Variant
    Dim strFilename As String
    Dim fileCount As Long
    Dim i As Long
    Dim j As Long
    
    Set objShellApp = CreateObject("Shell.Application")
    Set objFolder = objShellApp.Namespace("C:\Users\Domenic\Documents\Sounds") 'change the path to the source folder accordingly
    
    varColumns = Array(0, 20, 21, 28, 16, 14)
    
    ReDim arrData(0 To UBound(varColumns), 0 To objFolder.Items.Count)
    
    For i = LBound(arrData, 1) To UBound(arrData, 1)
        arrData(i, 0) = objFolder.GetDetailsOf(objFolder.Items, varColumns(i))
    Next i
    
    fileCount = 0
    For i = 0 To objFolder.Items.Count - 1
        strFilename = objFolder.GetDetailsOf(objFolder.Items.Item(CLng(i)), 0)
        If Right(strFilename, 4) = ".mp3" Or Right(strFilename, 4) = ".wav" Then
            fileCount = fileCount + 1
            For j = 0 To UBound(varColumns)
                arrData(j, fileCount) = objFolder.GetDetailsOf(objFolder.Items.Item(CLng(i)), varColumns(j))
            Next j
        End If
    Next i
    
    Worksheets.Add
    
    Range("A1").Resize(UBound(arrData, 2) + 1, UBound(arrData, 1) + 1).Value = Application.Transpose(arrData)
    
End Sub

Note that since I did not understand what you meant by "key of the song", it's not included in the result.

Hope this helps!

 

[TimvMechelen]

Thank you Domenic! When I run the macro I get: the name, contributing artists, title, bit rate, Genre and Album.
Do you know if there is a possibility to get the "Initial key" and the "Beats-per-minute" in Excel too (as you can see below)?

Again, Thanks a lot for your help!

 

[TimvMechelen]

I found a related page on this site for this I think. I only know some basics on VBA, so I don't get this. Maybe it can help you..
https://www.mrexcel.com/forum/excel...d-write-mp3-file-tag-properties-solved-2.html

 

[Repush]

based on the link you should add 221 (key) and 219 (BPM) to the varColumns-Array

varColumns = Array(0, 20, 21, 28, 16, 14, 221, 219)

 

[Domenic]

I've taken a look at that link, but found that the Shell property file values for Beats-per-minute and Initial key should actually be 243 and 247, respectively. Also, I've re-read your original post. Accordingly, try the following instead...

varColumns = Array(166, 13, 21, 243, 16, 14, 247)

The result should be in the following format...

[TABLE="width: 950"]
<tbody>[TR]
[TD="class: xl63, width: 64"]Filename[/TD]
[TD="class: xl63, width: 64"]Contributing artists[/TD]
[TD="class: xl63, width: 64"]Title[/TD]
[TD="class: xl63, width: 64"]Beats-per-minute[/TD]
[TD="class: xl63, width: 64"]Genre[/TD]
[TD="class: xl63, width: 64"]Album[/TD]
[TD="class: xl63, width: 64"]Initial key[/TD]
[/TR]
</tbody>[/TABLE]

Here is the list of Shell file properties that I get...

[TABLE="width: 300"]
<tbody>[TR]
[TD="class: xl65, width: 30, align: right"]0[/TD]
[TD="class: xl65, width: 64"]Name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]1[/TD]
[TD="class: xl65"]Size[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]2[/TD]
[TD="class: xl65"]Item type[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]3[/TD]
[TD="class: xl65"]Date modified[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]4[/TD]
[TD="class: xl65"]Date created[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]5[/TD]
[TD="class: xl65"]Date accessed[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]6[/TD]
[TD="class: xl65"]Attributes[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]7[/TD]
[TD="class: xl65"]Offline status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]8[/TD]
[TD="class: xl65"]Availability[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]9[/TD]
[TD="class: xl65"]Perceived type[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]10[/TD]
[TD="class: xl65"]Owner[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]11[/TD]
[TD="class: xl65"]Kind[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]12[/TD]
[TD="class: xl65"]Date taken[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]13[/TD]
[TD="class: xl65"]Contributing artists[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]14[/TD]
[TD="class: xl65"]Album[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]15[/TD]
[TD="class: xl65"]Year[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]16[/TD]
[TD="class: xl65"]Genre[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]17[/TD]
[TD="class: xl65"]Conductors[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]18[/TD]
[TD="class: xl65"]Tags[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19[/TD]
[TD="class: xl65"]Rating[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]20[/TD]
[TD="class: xl65"]Authors[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]21[/TD]
[TD="class: xl65"]Title[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]22[/TD]
[TD="class: xl65"]Subject[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]23[/TD]
[TD="class: xl65"]Categories[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]24[/TD]
[TD="class: xl65"]Comments[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]25[/TD]
[TD="class: xl65"]Copyright[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]26[/TD]
[TD="class: xl65"]#[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]27[/TD]
[TD="class: xl65"]Length[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]28[/TD]
[TD="class: xl65"]Bit rate[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]29[/TD]
[TD="class: xl65"]Protected[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]30[/TD]
[TD="class: xl65"]Camera model[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]31[/TD]
[TD="class: xl65"]Dimensions[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]32[/TD]
[TD="class: xl65"]Camera maker[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]33[/TD]
[TD="class: xl65"]Company[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl65"]File description[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]35[/TD]
[TD="class: xl65"]Masters keywords[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]36[/TD]
[TD="class: xl65"]Masters keywords[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]37[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]38[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]39[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]40[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]41[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]42[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]43[/TD]
[TD="class: xl65"]Program name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]44[/TD]
[TD="class: xl65"]Duration[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]45[/TD]
[TD="class: xl65"]Is online[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]46[/TD]
[TD="class: xl65"]Is recurring[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]47[/TD]
[TD="class: xl65"]Location[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]48[/TD]
[TD="class: xl65"]Optional attendee addresses[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]49[/TD]
[TD="class: xl65"]Optional attendees[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]50[/TD]
[TD="class: xl65"]Organizer address[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]51[/TD]
[TD="class: xl65"]Organizer name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]52[/TD]
[TD="class: xl65"]Reminder time[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]53[/TD]
[TD="class: xl65"]Required attendee addresses[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]54[/TD]
[TD="class: xl65"]Required attendees[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]55[/TD]
[TD="class: xl65"]Resources[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65"]Meeting status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]57[/TD]
[TD="class: xl65"]Free/busy status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]58[/TD]
[TD="class: xl65"]Total size[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]59[/TD]
[TD="class: xl65"]Account name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]60[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]61[/TD]
[TD="class: xl65"]Task status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]62[/TD]
[TD="class: xl65"]Computer[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]63[/TD]
[TD="class: xl65"]Anniversary[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]64[/TD]
[TD="class: xl65"]Assistant's name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]65[/TD]
[TD="class: xl65"]Assistant's phone[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]66[/TD]
[TD="class: xl65"]Birthday[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]67[/TD]
[TD="class: xl65"]Business address[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]68[/TD]
[TD="class: xl65"]Business city[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]69[/TD]
[TD="class: xl65"]Business country/region[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]70[/TD]
[TD="class: xl65"]Business P.O. box[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]71[/TD]
[TD="class: xl65"]Business postal code[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]72[/TD]
[TD="class: xl65"]Business state or province[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]73[/TD]
[TD="class: xl65"]Business street[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]74[/TD]
[TD="class: xl65"]Business fax[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]75[/TD]
[TD="class: xl65"]Business home page[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]76[/TD]
[TD="class: xl65"]Business phone[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]77[/TD]
[TD="class: xl65"]Callback number[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl65"]Car phone[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]79[/TD]
[TD="class: xl65"]Children[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]80[/TD]
[TD="class: xl65"]Company main phone[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]81[/TD]
[TD="class: xl65"]Department[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]82[/TD]
[TD="class: xl65"]E-mail address[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]83[/TD]
[TD="class: xl65"]E-mail2[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]84[/TD]
[TD="class: xl65"]E-mail3[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]85[/TD]
[TD="class: xl65"]E-mail list[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]86[/TD]
[TD="class: xl65"]E-mail display name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]87[/TD]
[TD="class: xl65"]File as[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]88[/TD]
[TD="class: xl65"]First name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]89[/TD]
[TD="class: xl65"]Full name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]90[/TD]
[TD="class: xl65"]Gender[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]91[/TD]
[TD="class: xl65"]Given name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]92[/TD]
[TD="class: xl65"]Hobbies[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]93[/TD]
[TD="class: xl65"]Home address[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]94[/TD]
[TD="class: xl65"]Home city[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]95[/TD]
[TD="class: xl65"]Home country/region[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]96[/TD]
[TD="class: xl65"]Home P.O. box[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]97[/TD]
[TD="class: xl65"]Home postal code[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65"]Home state or province[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]99[/TD]
[TD="class: xl65"]Home street[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]100[/TD]
[TD="class: xl65"]Home fax[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]101[/TD]
[TD="class: xl65"]Home phone[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]102[/TD]
[TD="class: xl65"]IM addresses[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]103[/TD]
[TD="class: xl65"]Initials[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]104[/TD]
[TD="class: xl65"]Job title[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]105[/TD]
[TD="class: xl65"]Label[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]106[/TD]
[TD="class: xl65"]Last name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]107[/TD]
[TD="class: xl65"]Mailing address[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]108[/TD]
[TD="class: xl65"]Middle name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]109[/TD]
[TD="class: xl65"]Cell phone[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]110[/TD]
[TD="class: xl65"]Nickname[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]111[/TD]
[TD="class: xl65"]Office location[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]112[/TD]
[TD="class: xl65"]Other address[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]113[/TD]
[TD="class: xl65"]Other city[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]114[/TD]
[TD="class: xl65"]Other country/region[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]115[/TD]
[TD="class: xl65"]Other P.O. box[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]116[/TD]
[TD="class: xl65"]Other postal code[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]117[/TD]
[TD="class: xl65"]Other state or province[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]118[/TD]
[TD="class: xl65"]Other street[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]119[/TD]
[TD="class: xl65"]Pager[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]120[/TD]
[TD="class: xl65"]Personal title[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]121[/TD]
[TD="class: xl65"]City[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]122[/TD]
[TD="class: xl65"]Country/region[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]123[/TD]
[TD="class: xl65"]P.O. box[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]124[/TD]
[TD="class: xl65"]Postal code[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]125[/TD]
[TD="class: xl65"]State or province[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]126[/TD]
[TD="class: xl65"]Street[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]127[/TD]
[TD="class: xl65"]Primary e-mail[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]128[/TD]
[TD="class: xl65"]Primary phone[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]129[/TD]
[TD="class: xl65"]Profession[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]130[/TD]
[TD="class: xl65"]Spouse/Partner[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]131[/TD]
[TD="class: xl65"]Suffix[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]132[/TD]
[TD="class: xl65"]TTY/TTD phone[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]133[/TD]
[TD="class: xl65"]Telex[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]134[/TD]
[TD="class: xl65"]Webpage[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]135[/TD]
[TD="class: xl65"]Content status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]136[/TD]
[TD="class: xl65"]Content type[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]137[/TD]
[TD="class: xl65"]Date acquired[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]138[/TD]
[TD="class: xl65"]Date archived[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]139[/TD]
[TD="class: xl65"]Date completed[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]140[/TD]
[TD="class: xl65"]Device category[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]141[/TD]
[TD="class: xl65"]Connected[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]142[/TD]
[TD="class: xl65"]Discovery method[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]143[/TD]
[TD="class: xl65"]Friendly name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]144[/TD]
[TD="class: xl65"]Local computer[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]145[/TD]
[TD="class: xl65"]Manufacturer[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]146[/TD]
[TD="class: xl65"]Model[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]147[/TD]
[TD="class: xl65"]Paired[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]148[/TD]
[TD="class: xl65"]Classification[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]149[/TD]
[TD="class: xl65"]Status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]150[/TD]
[TD="class: xl65"]Status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]151[/TD]
[TD="class: xl65"]Client ID[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]152[/TD]
[TD="class: xl65"]Contributors[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]153[/TD]
[TD="class: xl65"]Content created[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]154[/TD]
[TD="class: xl65"]Last printed[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]155[/TD]
[TD="class: xl65"]Date last saved[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]156[/TD]
[TD="class: xl65"]Division[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]157[/TD]
[TD="class: xl65"]Document ID[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]158[/TD]
[TD="class: xl65"]Pages[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]159[/TD]
[TD="class: xl65"]Slides[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]160[/TD]
[TD="class: xl65"]Total editing time[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]161[/TD]
[TD="class: xl65"]Word count[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]162[/TD]
[TD="class: xl65"]Due date[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]163[/TD]
[TD="class: xl65"]End date[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]164[/TD]
[TD="class: xl65"]File count[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]165[/TD]
[TD="class: xl65"]File extension[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]166[/TD]
[TD="class: xl65"]Filename[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]167[/TD]
[TD="class: xl65"]File version[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]168[/TD]
[TD="class: xl65"]Flag color[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]169[/TD]
[TD="class: xl65"]Flag status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]170[/TD]
[TD="class: xl65"]Space free[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]171[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]172[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]173[/TD]
[TD="class: xl65"]Group[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]174[/TD]
[TD="class: xl65"]Sharing type[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]175[/TD]
[TD="class: xl65"]Bit depth[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]176[/TD]
[TD="class: xl65"]Horizontal resolution[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]177[/TD]
[TD="class: xl65"]Width[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]178[/TD]
[TD="class: xl65"]Vertical resolution[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]179[/TD]
[TD="class: xl65"]Height[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]180[/TD]
[TD="class: xl65"]Importance[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]181[/TD]
[TD="class: xl65"]Is attachment[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]182[/TD]
[TD="class: xl65"]Is deleted[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]183[/TD]
[TD="class: xl65"]Encryption status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]184[/TD]
[TD="class: xl65"]Has flag[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]185[/TD]
[TD="class: xl65"]Is completed[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]186[/TD]
[TD="class: xl65"]Incomplete[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]187[/TD]
[TD="class: xl65"]Read status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]188[/TD]
[TD="class: xl65"]Shared[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]189[/TD]
[TD="class: xl65"]Creators[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]190[/TD]
[TD="class: xl65"]Date[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]191[/TD]
[TD="class: xl65"]Folder name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]192[/TD]
[TD="class: xl65"]Folder path[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]193[/TD]
[TD="class: xl65"]Folder[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]194[/TD]
[TD="class: xl65"]Participants[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]195[/TD]
[TD="class: xl65"]Path[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]196[/TD]
[TD="class: xl65"]By location[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]197[/TD]
[TD="class: xl65"]Type[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]198[/TD]
[TD="class: xl65"]Contact names[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]199[/TD]
[TD="class: xl65"]Entry type[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]200[/TD]
[TD="class: xl65"]Language[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]201[/TD]
[TD="class: xl65"]Date visited[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]202[/TD]
[TD="class: xl65"]Description[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]203[/TD]
[TD="class: xl65"]Link status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]204[/TD]
[TD="class: xl65"]Link target[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]205[/TD]
[TD="class: xl65"]URL[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]206[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]207[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]208[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]209[/TD]
[TD="class: xl65"]Media created[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]210[/TD]
[TD="class: xl65"]Date released[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]211[/TD]
[TD="class: xl65"]Encoded by[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]212[/TD]
[TD="class: xl65"]Episode number[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]213[/TD]
[TD="class: xl65"]Producers[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]214[/TD]
[TD="class: xl65"]Publisher[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]215[/TD]
[TD="class: xl65"]Season number[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]216[/TD]
[TD="class: xl65"]Subtitle[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]217[/TD]
[TD="class: xl65"]User web URL[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]218[/TD]
[TD="class: xl65"]Writers[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]219[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]220[/TD]
[TD="class: xl65"]Attachments[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]221[/TD]
[TD="class: xl65"]Bcc addresses[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]222[/TD]
[TD="class: xl65"]Bcc[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]223[/TD]
[TD="class: xl65"]Cc addresses[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]224[/TD]
[TD="class: xl65"]Cc[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]225[/TD]
[TD="class: xl65"]Conversation ID[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]226[/TD]
[TD="class: xl65"]Date received[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]227[/TD]
[TD="class: xl65"]Date sent[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]228[/TD]
[TD="class: xl65"]From addresses[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]229[/TD]
[TD="class: xl65"]From[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]230[/TD]
[TD="class: xl65"]Has attachments[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]231[/TD]
[TD="class: xl65"]Sender address[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]232[/TD]
[TD="class: xl65"]Sender name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]233[/TD]
[TD="class: xl65"]Store[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]234[/TD]
[TD="class: xl65"]To addresses[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]235[/TD]
[TD="class: xl65"]To do title[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]236[/TD]
[TD="class: xl65"]To[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]237[/TD]
[TD="class: xl65"]Mileage[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]238[/TD]
[TD="class: xl65"]Album artist[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]239[/TD]
[TD="class: xl65"]Sort album artist[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]240[/TD]
[TD="class: xl65"]Album ID[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]241[/TD]
[TD="class: xl65"]Sort album[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]242[/TD]
[TD="class: xl65"]Sort contributing artists[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]243[/TD]
[TD="class: xl65"]Beats-per-minute[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]244[/TD]
[TD="class: xl65"]Composers[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]245[/TD]
[TD="class: xl65"]Sort composer[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]246[/TD]
[TD="class: xl65"]Disc[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]247[/TD]
[TD="class: xl65"]Initial key[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]248[/TD]
[TD="class: xl65"]Part of a compilation[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]249[/TD]
[TD="class: xl65"]Mood[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]250[/TD]
[TD="class: xl65"]Part of set[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]251[/TD]
[TD="class: xl65"]Period[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]252[/TD]
[TD="class: xl65"]Color[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]253[/TD]
[TD="class: xl65"]Parental rating[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]254[/TD]
[TD="class: xl65"]Parental rating reason[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]255[/TD]
[TD="class: xl65"]Space used[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]256[/TD]
[TD="class: xl65"]EXIF version[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]257[/TD]
[TD="class: xl65"]Event[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]258[/TD]
[TD="class: xl65"]Exposure bias[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]259[/TD]
[TD="class: xl65"]Exposure program[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]260[/TD]
[TD="class: xl65"]Exposure time[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]261[/TD]
[TD="class: xl65"]F-stop[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]262[/TD]
[TD="class: xl65"]Flash mode[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]263[/TD]
[TD="class: xl65"]Focal length[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]264[/TD]
[TD="class: xl65"]35mm focal length[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]265[/TD]
[TD="class: xl65"]ISO speed[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]266[/TD]
[TD="class: xl65"]Lens maker[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]267[/TD]
[TD="class: xl65"]Lens model[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]268[/TD]
[TD="class: xl65"]Light source[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]269[/TD]
[TD="class: xl65"]Max aperture[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]270[/TD]
[TD="class: xl65"]Metering mode[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]271[/TD]
[TD="class: xl65"]Orientation[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]272[/TD]
[TD="class: xl65"]People[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]273[/TD]
[TD="class: xl65"]Program mode[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]274[/TD]
[TD="class: xl65"]Saturation[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]275[/TD]
[TD="class: xl65"]Subject distance[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]276[/TD]
[TD="class: xl65"]White balance[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]277[/TD]
[TD="class: xl65"]Priority[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]278[/TD]
[TD="class: xl65"]Project[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]279[/TD]
[TD="class: xl65"]Channel number[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]280[/TD]
[TD="class: xl65"]Episode name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]281[/TD]
[TD="class: xl65"]Closed captioning[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]282[/TD]
[TD="class: xl65"]Rerun[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]283[/TD]
[TD="class: xl65"]SAP[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]284[/TD]
[TD="class: xl65"]Broadcast date[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]285[/TD]
[TD="class: xl65"]Program description[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]286[/TD]
[TD="class: xl65"]Recording time[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]287[/TD]
[TD="class: xl65"]Station call sign[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]288[/TD]
[TD="class: xl65"]Station name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]289[/TD]
[TD="class: xl65"]Summary[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]290[/TD]
[TD="class: xl65"]Snippets[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]291[/TD]
[TD="class: xl65"]Auto summary[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]292[/TD]
[TD="class: xl65"]Relevance[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]293[/TD]
[TD="class: xl65"]File ownership[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]294[/TD]
[TD="class: xl65"]Sensitivity[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]295[/TD]
[TD="class: xl65"]Shared with[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]296[/TD]
[TD="class: xl65"]Sharing status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]297[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]298[/TD]
[TD="class: xl65"]Product name[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]299[/TD]
[TD="class: xl65"]Product version[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]300[/TD]
[TD="class: xl65"]Support link[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]301[/TD]
[TD="class: xl65"]Source[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]302[/TD]
[TD="class: xl65"]Start date[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]303[/TD]
[TD="class: xl65"]Sharing[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]304[/TD]
[TD="class: xl65"]Availability status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]305[/TD]
[TD="class: xl65"]Status[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]306[/TD]
[TD="class: xl65"]Billing information[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]307[/TD]
[TD="class: xl65"]Complete[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]308[/TD]
[TD="class: xl65"]Task owner[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]309[/TD]
[TD="class: xl65"]Sort title[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]310[/TD]
[TD="class: xl65"]Total file size[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]311[/TD]
[TD="class: xl65"]Legal trademarks[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]312[/TD]
[TD="class: xl65"]Video compression[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]313[/TD]
[TD="class: xl65"]Directors[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]314[/TD]
[TD="class: xl65"]Data rate[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]315[/TD]
[TD="class: xl65"]Frame height[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]316[/TD]
[TD="class: xl65"]Frame rate[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]317[/TD]
[TD="class: xl65"]Frame width[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]318[/TD]
[TD="class: xl65"]Spherical[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]319[/TD]
[TD="class: xl65"]Stereo[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]320[/TD]
[TD="class: xl65"]Video orientation[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]321[/TD]
[TD="class: xl65"]Total bitrate[/TD]
[/TR]
</tbody>[/TABLE]

 

[TimvMechelen]

This doesn't work unfortunately

 

[TimvMechelen]

I've taken a look at that link, but found that the Shell property file values for Beats-per-minute and Initial key should actually be 243 and 247, respectively. Also, I've re-read your original post. Accordingly, try the following instead...

varColumns = Array(166, 13, 21, 243, 16, 14, 247)

This works!! Thanks a lot!!

A small other question:
Is it possible to rename the added sheet to the specific folder name?

 

[Domenic]

Sure, try...

Worksheets.Add.Name = objFolder.Title

 

[TimvMechelen]

Is it possible to have the path to the source folder in cell A1 on sheet 1? So that I dont have to change the VBA code every time I want an other folder, but just only paste the new folder path in cell A1 on sheet 1.