title: VBA compare two folders to find the differents files
body: <p>I have 2 folders <strong>textFiles</strong> &amp; <strong>excelFiles</strong>, They have the same filename but with different extensions (for textFiles = .txt  &amp; excelFiles = .xlsx), 
  I write a code, to find if a file in textFiles doesn't exist in excelFiles to call a function who create it.</p>
  
  <pre><code>Sub LookForNew()
  Dim dTxt As String
  Set fso = CreateObject("Scripting.FileSystemObject")
  Set filsTxt = fso.GetFolder("C:\txtFiles").Files
  Set filsExcel = fso.GetFolder("C:\excelFiles").Files
  Set oFileExcel = CreateObject("Scripting.Dictionary")
  Set tFileExl = CreateObject("Scripting.Dictionary")
  Set oFileExl = CreateObject("Scripting.Dictionary")
  For Each fil In filsTxt
    dTxt = fil.Name
      For Each exl In filsExcel
         oFileExcel = exl.Name
         oFileExl = Split(oFileExcel, ".")
         tFileExl = oFileExl(0)
          Next exl
          If Not (tFileExl.Exists(dTxt)) Then
             ' Call function
          Else
          MsgBox "No more files to convert"
          End If
  Next fil
  Set fso = Nothing
  </code></pre>
  
  <p>End Sub</p>
  
  <p>But the field "oFileExcel" in my code doesn't return an Dictionary but a string
  Help plz</p>