文件批量改名的程序

赵嘉浚

各位：我原来有一段“文件批量改名”的代码，是加一个后缀，现在要修改文件名的几个字（也就是替换）该用什么思路呢？
请高手指教，谢谢！！

Sub 批量改名()
    Dim MyPath$, MyFile$, wb As Workbook, c
    Application.ScreenUpdating = False
    Application.DisplayAlerts = False
    Application.Visible = False
    With Application.FileDialog(4)
        MsgBox "请选择你要处理的文件夹。"
        c = .Show
        If c = 0 Then
            Exit Sub
        Else
            MyPath = .SelectedItems(1) & "\"
        End If
    End With
    MyFile = Dir(MyPath)
    Do
        If MyFile <> ThisWorkbook.Name Then
            Set wb = GetObject(MyPath & MyFile)
            wb.SaveAs wb.Name & "201404" & ".xlsx"
            wb.Close True
            Kill MyPath & MyFile
            'Worksheets("201402").Move before:=Worksheets("201403")
        End If
        MyFile = Dir
    Loop While MyFile <> ""
    Application.ScreenUpdating = True
    Application.DisplayAlerts = True
   
    Shell "Explorer.exe " & MyPath, 1
    Application.Visible = True
    Application.Quit
End Sub

mll-人事部-王勇

Sub 取名()
    Dim a(), arr, i%, myPath$, mn$
    With Application.FileDialog(4)
        s = .Show
        If s <> 0 Then
            st = .SelectedItems(1)
        Else
            Exit Sub
        End If
    End With
    myPath = st & "\"
    myname = Dir(myPath, vbDirectory)
    mn = ThisWorkbook.Name
    Range("a2:a65536") = ""
    Do While myname <> ""
    If myname <> "." And myname <> ".." And myname <> mn Then
        If (GetAttr(myPath & myname) And vbDirectory) = vbDirectory Then
         i = i + 1
        ReDim Preserve a(i)
        a(i) = myname & "\"
        Else
        i = i + 1
        ReDim Preserve a(i)
        a(i) = myname
        End If
    End If
    myname = Dir
    Loop
    k = 1
    For j = 2 To i + 1
    Cells(j, 1) = a(k) & MyWjName
    k = k + 1
    Next
    [O1] = myPath
End Sub
Sub 改名()
myPath = [O1]
ma = [a65536].End(3).Row
For i = 2 To ma
Name myPath & Cells(i, 1) As myPath & Cells(i, 2)
Next i
End Sub


分两步呗、乱凑了一个以前的代码、先取文件夹下的文件名称 到表的A列 ，然后通过操作表格在B列改好对应的名称 然后用B列的名称去给文件命名。

赵嘉浚

谢谢~~~~~~~