|
- Sub 导入文件()
- Application.ScreenUpdating = False
- Dim Filename, wb As Workbook, Sht As Worksheet
- Filename = Dir(ThisWorkbook.Path & "\*.xls")
- arr = Range("a1:e1000"): n = 1
- Do While Filename <> ""
- If Filename <> ThisWorkbook.Name Then
- fn = ThisWorkbook.Path & "" & Filename
- Set wb = Workbooks.Open(fn)
- Set Sht = wb.Worksheets("设备概况")
- n = n + 1: arr(n, 1) = n - 1
- For j = 2 To 5
- x = arr(1, j)
- Set xrng = Sht.UsedRange.Find(x)
- If Not xrng Is Nothing Then arr(n, j) = xrng.Offset(0, 1)
- Next
- wb.Close False
- End If
- Filename = Dir
- Loop
- Set Sht = Nothing
- [a1].Resize(n, 5) = arr
- ActiveSheet.Columns.AutoFit
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|