|
查找:
Sub test()
Dim wb As Workbook, sh As Worksheet, c As Range, ar()
If Trim([b4]) = "" Then Exit Sub
s$ = Trim([b4])
fp$ = ThisWorkbook.Path & "\资料\"
fn$ = Dir(fp & "*.xls*")
ReDim ar(1 To 2)
Application.ScreenUpdating = 0
Do While fn <> ""
Set wb = Workbooks.Open(fp & fn)
For Each sh In wb.Worksheets
Set c = sh.Cells.Find(s)
If Not c Is Nothing Then
r = r + 1
If r > UBound(ar) Then ReDim Preserve ar(1 To r + 100)
ar(r) = fp & fn & "\" & sh.Name
End If
Next
wb.Close 0
fn$ = Dir
Loop
Range("a9:f" & [a65536].End(3).Row).ClearContents
[a9].Resize(r, 1) = Application.Transpose(ar)
End Sub
单元格事件:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column > 1 Then Exit Sub
If Target.Row < 9 Then Exit Sub
s = Target(1).Text
If s = "" Then Exit Sub
Set wb = Workbooks.Open(Left(s, InStrRev(s, "\") - 1))
wb.Sheets(Mid(s, InStrRev(s, "\") + 1)).Select
End Sub |
评分
-
查看全部评分
|