|
- Sub 提取数据123()
- Dim wb As Workbook
- Dim brr(1 To 4, 1 To 100)
- Dim mypath$, myname$
- Application.DisplayAlerts = False
- Application.ScreenUpdating = False
- mypath = ThisWorkbook.Path & ""
- myname = Dir(mypath & "*.xl*")
- Do While myname <> ""
- If myname <> ThisWorkbook.Name Then
- n = n + 1
- Set wb = GetObject(mypath & myname)
- With wb
- With .Worksheets("sheet1")
- brr(1, n) = Split(wb.Name, ".")(0)
- brr(2, n) = .[d2]
- brr(3, n) = .[d5]
- brr(4, n) = .[d8]
- End With
- wb.Close False
- End With
- End If
- myname = Dir()
- Loop
- With ThisWorkbook.Worksheets("sheet1")
- .[b1].Resize(4, n) = brr
- End With
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- MsgBox "数据提取完成!"
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|