Filter data (Date) and save in new file

I have file config and input as attached.

I want to filter column APAPDT in file input by read condition by file config
Condition : Column APAPDT (format = yyyyddmm)
value input >= APAPDT1 and value input <= APAPDT2

I want output after filter save in filename follow filename in column File Name in file config.

Please guide me about it.

remark : My real data have input 300K rows

According to Logic with such numbers rather than true Excel dates the format must be yyyymmdd …

Anyway according to your attachment a VBA demonstration as a starting point
you should amend for what you misexplained or did not ever elaborate :

PHP Code: 

Sub Demo1()
    Dim V, R&
        On Error Resume Next
    With Workbooks("input22.xlsx").Worksheets(1).[A1].CurrentRegion
        V = Workbooks("Config.xlsx").Worksheets(1).[A1].CurrentRegion.Value2
        If Err.Number Then Beep: Exit Sub
        On Error GoTo 0
        Application.DisplayAlerts = False
        Application.ScreenUpdating = False
       .Range("D1").Copy .Range("Y1:Z1")
        Workbooks.Add xlWBATWorksheet
    For R = 2 To UBound(V)
       .Range("Y2:Z2").Value2 = Array(">=" & V(R, 1), "<=" & V(R, 2))
       .AdvancedFilter 2, .Range("Y1:Z2"), ActiveSheet.[A1]
        ActiveWorkbook.SaveAs .Parent.Parent.Path & "\" & V(R, 3), 51
        ActiveSheet.UsedRange.Clear
    Next
       .Range("Y1:Z2").Clear
    End With
        ActiveWorkbook.Close
        Application.DisplayAlerts = True
        Application.ScreenUpdating = True
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

I can't run your this code.

It go to Err.Number

Please guide me about it.

As no such issue on my side so according to the code did you obviously just forget to open both workbooks ?