VBA compare two folders to find the differents files
<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>