Append multiple DBF files in PowerQuery with with a changing path

Hello, I need to Append multiple DBF files, but every time I have difference path (folder)
I have code :


fnGetDBF

(MyPath, MyFile) =>
let
    Source = Odbc.DataSource("dsn=dBASE Files", [HierarchicalNavigation=true]),
    Database = Source{[Name=MyPath,Kind="Database"]}[Data],
    Table = Database{[Name=MyFile,Kind="Table"]}[Data]
//  Your transformations here

in
    Table

Use this function to combine all the dbf tables in a folder:

CombineDBFTables

let
    Source = Folder.Files("C:\YourPath\DBF"),
    #"Filtered Rows" = Table.SelectRows(Source, each [Extension] = ".dbf"),
    #"Added MyPath" = Table.AddColumn(#"Filtered Rows", "MyPath", each Text.TrimEnd([Folder Path],"\")),
    #"Added MyFile" = Table.AddColumn(#"Added MyPath", "MyFile", each Text.Replace([Name],[Extension],"")),
    #"Get Tables" = Table.AddColumn(#"Added MyFile", "fnGetDBF", each fnGetDBF([MyPath], [MyFile])),
    #"Combine Tables" = Table.Combine(#"Get Tables"[fnGetDBF])
in
    #"Combine Tables"

BUT when I try to change the Path in red with fnGetDBF the code didn't work.

Can you someone help me, please.

I tried to export them from the excel source, with simple excel function like

=LEFT(CELL("filename"),FIND("[",CELL("filename"))-1)

This is my Excel file. It's work with specific file path.