|
发表于 2015-1-15 13:02
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim d, mypath$, wj$, i%
- Set d = CreateObject("scripting.dictionary")
- mypath = ThisWorkbook.Path & ""
- For i = 1 To 1000
- z = "第" & Application.Text(i, "[dbnum1]")
- d(z) = "第" & i
- Next
- For i = 10 To 19
- z = "第" & Mid(Application.Text(i, "[dbnum1]"), 2)
- d(z) = "第" & i
- Next
- wj = Dir(mypath & "*.txt")
- Do While wj <> ""
- x = Split(wj, "课")(0)
- zf = Replace(wj, x, d(x))
- Name mypath & wj As mypath & zf
- wj = Dir
- Loop
- End Sub
复制代码 |
评分
-
查看全部评分
|