Dear All master,
I just want the file name in column c and the extension in column d.
The result I want is marked in yellow.
this is my link : result.xlsm
file
Thanks
roykana
Sub ListAllFilesInAllFolders()
Dim MyPath As String, MyFolderName As String, MyFileName As String
Dim i...