|
发表于 2014-10-12 17:03
|
显示全部楼层
本楼为最佳答案
Dim d
Sub test()
Dim A, i
Range("b:b").ClearContents
A = Range("a1:b" & Range("a65536").End(3).Row)
Call test2 '建字典
For i = 1 To UBound(A)
A(i, 2) = d(A(i, 1))
Next i
[a1].Resize(i - 1, 2) = A
End Sub
Sub test2()
Dim p, f, i, arr
Set d = CreateObject("scripting.dictionary")
p = ThisWorkbook.Path
f = Dir(p & "\*.txt")
Do While f <> ""
Open p & "\" & f For Input As #1
arr = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbCrLf)
Close #1
f = VBA.Replace(f, ".txt", "")
For i = 0 To UBound(arr)
d(arr(i)) = f
Next i
f = Dir
Loop
End Sub
国家或地区2.rar
(14.6 KB, 下载次数: 15)
|
评分
-
查看全部评分
|