|
本帖最后由 wanao2008 于 2016-7-13 20:26 编辑
去掉第4句的 On Error Resume Next
把第15句 d.Add arrf(i), "" 改成 d(arrf(i)) = ""- Sub 去重复()
- Dim Fso As Object, Folder As Object, d As Object
- Dim arrf$(), mf&, MyPath$
- 'On Error Resume Next
- With Application.FileDialog(msoFileDialogFolderPicker)
- .InitialFileName = ThisWorkbook.Path & ""
- If .Show = False Then Exit Sub
- MyPath = .SelectedItems(1) & ""
- End With
- Set d = CreateObject("Scripting.Dictionary") '这个字典不知怎么用才能实现去重?
- Set Fso = CreateObject("Scripting.FileSystemObject")
- Set Folder = Fso.GetFolder(MyPath)
- Call GetFiles(Folder, arrf, mf)
- For i = 1 To UBound(arrf)
- d(arrf(i)) = ""
- Next
- x = d.Count
- brr = d.Keys
- [B8].Resize(1, x) = brr
- Set Folder = Nothing
- Set Fso = Nothing
- End Sub
复制代码 |
评分
-
查看全部评分
|