|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 vvw123 于 2019-3-13 22:58 编辑
论坛有个大侠的代码,但是不会修改,一修改就出错。要求把各科成绩汇总到一个表格。--------------------------------------------------------------------------------------------------------------------
感谢lsc900707版主强大易懂的代码,他的代码接触了不少,奈何本人愚笨,学习不会进步。
下面分享下代码
- Sub gj23w98()
- Set d = CreateObject("scripting.dictionary")
- p = ThisWorkbook.Path & ""
- f = Dir(p & "*.xls*")
- Application.ScreenUpdating = False
- Do While f <> ""
- If f <> ThisWorkbook.Name Then
- Set wb = Workbooks.Open(p & f)
- ar = wb.Sheets(1).[a1].CurrentRegion
- For i = 3 To UBound(ar)
- For j = 6 To UBound(ar, 2)
- s = ar(i, 5) & ar(2, j)
- If Len(ar(i, j)) Then d(s) = ar(i, j)
- Next
- Next
- wb.Close False
- End If
- f = Dir
- Loop
- br = [a1].CurrentRegion
- For i = 3 To UBound(br)
- For j = 6 To UBound(br, 2)
- s = br(i, 5) & br(2, j)
- br(i, j) = d(s)
- Next
- Next
- [a1].CurrentRegion = br
- Application.ScreenUpdating = True
- MsgBox "各科成绩合并完成!", 64
- End Sub
复制代码
|
|