|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Option Explicit
Sub test()
Dim d As Object, p$, f$, s$
Set d = CreateObject("Scripting.Dictionary")
p = ThisWorkbook.Path & "\"
f = Dir(p & "*.xls*")
Do While f <> ""
If f <> ThisWorkbook.Name Then
s = Replace(f, ".xlsx", ".xls")
d(s) = d(s) + 1
End If
f = Dir
Loop
f = Dir(p & "*.xls*")
Do While f <> ""
If f <> ThisWorkbook.Name Then
s = Replace(f, ".xlsx", ".xls")
If d(s) = 1 Then Kill p & f
End If
f = Dir
Loop
Set d = Nothing
End Sub |
评分
-
2
查看全部评分
-
|