|
- Sub 提取数据()
- Dim wb As Workbook
- Dim brr(1 To 1000, 1 To 4)
- 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("封面")
- brr(n, 1) = .[c6]
- brr(n, 2) = .[c8]
- End With
- With .Worksheets("01-4(配网)")
- brr(n, 3) = .[g15]
- brr(n, 4) = .[g16]
- End With
- wb.Close False
- End With
- End If
- myname = Dir()
- Loop
- With ThisWorkbook.Worksheets("sheet1")
- .[a3].Resize(n, 4) = brr
- End With
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- MsgBox "数据提取完成!"
- End Sub
复制代码 |
评分
-
2
查看全部评分
-
|