|
Sub 宏1()
Application.ScreenUpdating = False
Dim dlgOpen As FileDialog
Dim d As Object
Dim ar As Variant
Dim br()
Set d = CreateObject("scripting.dictionary")
Set dlgOpen = Application.FileDialog(msoFileDialogFolderPicker)
With dlgOpen
If .Show <> -1 Then MsgBox "您没有选择文件夹!": Exit Sub
lj = .SelectedItems(1)
End With
ReDim br(1 To 100000, 1 To 1)
f = Dir(lj & "\*.html")
Do While f <> ""
Set wb = Workbooks.Open(lj & "\" & f, 0)
With wb.Worksheets(1)
r = .Cells(Rows.Count, 1).End(xlUp).Row
ar = .Range("a1:a" & r)
End With
wb.Close False
For i = 1 To UBound(ar)
If ar(i, 1) <> "" Then
If InStr(ar(i, 1), ".") > 0 Then
zf = Split(ar(i, 1), ".")(1)
If zf <> "" Then
If Not d.exists(zf) Then
n = n + 1
br(n, 1) = zf
End If
End If
End If
End If
Next i
f = Dir
Loop
If n <> "" Then
Columns(2) = Empty
[b1].Resize(n, 1) = br
End If
Application.ScreenUpdating = True
MsgBox "ok!"
End Sub
|
|