|
- Sub 导入文件()
- Application.DisplayAlerts = False
- Dim Filename, wb As Workbook, Sht As Worksheet
- Set Sht = ActiveSheet
- Filename = Dir(ThisWorkbook.Path & "\*.xls")
- r = Sht.[a65536].End(3).Row
- Do While Filename <> ""
- If Filename <> ThisWorkbook.Name Then
- fn = ThisWorkbook.Path & "" & Filename
- Set wb = Workbooks.Open(fn)
- With wb.Worksheets(1)
- r = r + 1
- Sht.Cells(r, 1).Resize(1, 5) = Array(.[b2], .[c3], .[f3], .[c73], .[c86])
- Set xrng = .[a:a].Find("指导", lookat:=xlWhole)
- If Not xrng Is Nothing Then Sht.Cells(r, 6) = xrng.Offset(-1, 1)
- End With
- wb.Close False
- End If
- Filename = Dir
- Loop
- Set Sht = Nothing
- Application.DisplayAlerts = True
- End Sub
复制代码 |
评分
-
查看全部评分
|