Dim strFolder As String Dim strFile As String strFolder = "C:\Dave\" strFile = Dir(strFolder & "\*.*") Do While Len(strFile) > 0 If InStr(strFile, "Model (1)") > 0 Then Name strFolder & strFile As strFolder & Replace(strFile, " Model (1)", "") End If strFile = Dir() Loop




Reply With Quote