Combine recursive listing with excluded code

[anmac1789]

it seems like there is still a problem with the parent folder column (column 2). For example,

folder path : C:\test with spaces
parent folder: C:\
which is correct. But,

folder path: C:\test with spaces\file1.txt
parent folder: C:\ ????
which is not correct because, file1.txt resides in the C:\test with spaces\ folder

I just can't seem to understand what & where "s" variable is and where its defined in the code, because the only s i see is in "sParentFolder" is this why you have chosen s?

Private Function RemovePrefix(s As String) As String
    If Len(s) < 5 Then
        RemovePrefix = s
    Else
        RemovePrefix = IIf(Left(s, 4) = "\\?\", Right(s, Len(s) - 4), s)
    End If
End Function