|
附件中“周琦”格式不对,改过来了。另外折扣不知怎么算。- Sub 导入文件()
- Application.ScreenUpdating = False
- Dim Filename, wb As Workbook, Sht As Worksheet
- Filename = Dir(ThisWorkbook.Path & "\*.xls")
- Dim brr(1 To 1000, 1 To 12)
- Do While Filename <> ""
- If Filename <> ThisWorkbook.Name Then
- fn = ThisWorkbook.Path & "" & Filename
- Set wb = Workbooks.Open(fn)
- For Each Sht In wb.Worksheets
- n = n + 1
- brr(n, 2) = Sht.[b3] '姓名
- brr(n, 5) = Sht.[I4] '手机号
- If Len(Sht.[M3]) > 0 Then brr(n, 5) = Sht.[M3] '最佳联系方式
- brr(n, 7) = Sht.[d3] '生日
- arr = Sht.Range("a19:i30")
- For i = 2 To UBound(arr)
- If Len(arr(i, 1)) = 0 Then arr(i, 1) = arr(i - 1, 1)
- jf = arr(i, 8) '积分
- If jf > 0 Then
- nf = Left(arr(i, 1), 4) '年
- If nf = "2015" Then brr(n, 8) = brr(n, 8) + jf '2015年积分
- If nf = "2014" Then brr(n, 9) = brr(n, 9) + jf '2014年积分
- End If
- Next
- Next
- wb.Close False
- End If
- Filename = Dir
- Loop
- Set Sht = Nothing
- r = [b65536].End(3).Row + 1
- If n > 0 Then Cells(r, 1).Resize(n, 12) = brr
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|