|
我想提取一个文件夹里的文件,文件名称是有规律的4-1,4-2,4-3,到4-31,提取出来的数值放在A1,A2,A3到A31,提取的数值放在(曲线图excel表里),每天增加一个或两个excel文件,比如新增了4-3文件,然后曲线图文件的A3就自动有了4-3文件的最大的数值。真心希望哪位高手能帮帮我,先谢谢了!
- Sub 导入文件()
- Application.ScreenUpdating = False
- Dim Filename, wb As Workbook, Sht As Worksheet
- Filename = Dir(ThisWorkbook.Path & "\*.xls")
- Do While Filename <> ""
- If Filename <> ThisWorkbook.Name Then
- fn = ThisWorkbook.Path & "" & Filename
- Set wb = Workbooks.Open(fn)
- rq = Val(Split(wb.Name, "-")(1)) '日期(可作为表中的行数使用)
- Set Sht = wb.Worksheets(1)
- x = Application.WorksheetFunction.Max(Sht.UsedRange) '最大值
- wb.Close False
- End If
- Cells(rq, 1) = x
- Filename = Dir
- Loop
- Set Sht = Nothing
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|