|
- Sub 导入文件() '从当前文件夹下不同表导入数据
- Dim Filename$, fn$, dq$, wb As Workbook, sh As Worksheet
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Dim brr(1 To 1000, 1 To 2)
- Filename = Dir(ThisWorkbook.Path & "\门诊\*.*")
- [a2:b1000] = ""
- Do While Filename <> ""
- fn = ThisWorkbook.Path & "\门诊" & Filename
- Set wb = Workbooks.Open(fn)
- Set sh = wb.Sheets(1)
- n = n + 1
- Cells(n + 1, 1) = "'" & Filename: Cells(n + 1, 2) = sh.[d2]
- wb.Close False
- Filename = Dir
- Loop
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|