|
本帖最后由 1261181315a 于 2016-3-24 13:59 编辑
现在需要根据excel汇总表,将每个人的部分信息汇总到word表格中。请各位老师帮忙看看,谢谢!
用excel操作word - Sub Macro1()
- Dim wd, arr, i&, j%
- Set wd = CreateObject("word.application")
- arr = Range("a1").CurrentRegion
- With wd.Documents.Open(ThisWorkbook.Path & "\汇总数据.doc")
- Set b = .Tables(1)
- r = b.Rows.Count
- For i = 2 To r
- b.Cell(i, 11).Range = arr(i, 6)
- b.Cell(i, 13).Range = arr(i, 7)
- For j = 1 To 5
- b.Cell(i, j).Range = arr(i, j)
- Next
- Next
- .Close True
- End With
- wd.Quit
- End Sub
复制代码
|
|