|
发表于 2021-10-31 21:17
|
显示全部楼层
本楼为最佳答案
试试下面代码,增加蓝色部份
Sub demo()
Set doc = GetObject(ThisWorkbook.Path & "\demo.docx")
[f5:h99].ClearContents
With doc.tables(1)
For i = 2 To .Rows.Count
s = ""
For j = 1 To .Columns.Count
s = s + "," + replace(.Cell(i, j).Range.Text,chr(13) & chr(7),"")
Next
[f5].Offset(r).Resize(, 3) = Array(Mid(s, 2, 99), , replace(.Cell(i, 2).Range.Text,chr(13) & chr(7),""))
r = r + 1
Next
End With
End Sub
|
|