|
- Sub TIQI()
- Dim Filename As String, mypath As String, k As Integer
- Dim wb As Workbook, sh As Worksheet, brr(0 To 100, 1 To 6), thiswb
- ' On Error Resume Next
- ' Application.DisplayAlerts = False '表示禁止显示提示和警告消息
- ' Application.ScreenUpdating = False '表示停止屏幕更新
- thiswb = ThisWorkbook.Name
- mypath = ThisWorkbook.Path & ""
- Range("B4:G100").ClearContents
- Filename = Dir(mypath & "*.xls")
- Do
- If Filename <> thiswb Then
- k = k + 1
- M = 0
- Set wb = Workbooks.Open(mypath & Filename)
- brr(M, k) = wb.Name
- For Each sh In wb.Worksheets
- M = M + 1
- brr(M, k) = sh.Name
- Next sh
- wb.Close False
- End If
- Filename = Dir
- Loop Until Filename = ""
- Range("B4:G100") = brr
- MsgBox "提取成功!"
- Application.DisplayAlerts = True '表示显示提示和警告消息
- Application.ScreenUpdating = True '表求启用屏幕更新
- End Sub
复制代码 |
评分
-
查看全部评分
|