I have a macro to search duplicate file name in excel file (LogFile.xlsx). If found show it on macro file (SearchDuplicate.xlsm) otherwise insert the file name in logfile.
Please !! help !
Sub Button1_Click()
Dim MyFolder As String, MyFile As String
Dim LastRowLogFile As Long, m As Long
Dim...