|
发表于 2013-3-29 23:07
|
显示全部楼层
本楼为最佳答案
Sub 按钮1_Click()
Dim p, f, i, j, wk1, sh1, wk2, sh2
Application.ScreenUpdating = False
Set wk1 = ThisWorkbook
Set sh1 = wk1.Sheets(1)
sh1.Range("a2:b5555").Clear
p = wk1.Path & "\"
f = Dir(p)
i = 2
j = 1
Do While f <> ""
If f <> wk1.Name Then
sh1.Cells(i, 1) = Left(f, Len(f) - 4)
sh1.Hyperlinks.Add Anchor:=sh1.Cells(i, 1), Address:=p & f
Set wk2 = Workbooks.Open(p & f)
With wk2
For Each sh2 In .Sheets
j = j + 1
sh1.Cells(j, 2) = sh2.Name
sh2.Hyperlinks.Add Anchor:=sh1.Cells(j, 2), Address:=p & f, SubAddress:="#" & sh2.Name & "!a1"
Next sh2
.Close 0
End With
i = j
End If
f = Dir
Loop
End Sub |
评分
-
查看全部评分
|