使用VB读取word中的表格内容到excel表格中
Sub 测试word到excel()
Dim excel As Object
Dim workbook As Object
Dim worksheet As Object
Dim i As Integer
Dim row As Integer
Dim str As String
Set excel = CreateObject("excel.application")
Set workbook = excel.WorkBooks.Open("c:\temp.xls")
Set worksheet = workbook.WorkSheets(1)
row = 2
For i = 1 To ActiveDocument.Tables(1).Rows.count
str = ActiveDocument.Tables(1).Cell(i, 3).Range.Text
worksheet.Cells(row, 1).Value = str
MsgBox "行:" & i & " 内容:" & str
row = row + 1
Next
excel.Visible = True
End Sub
扫描二维码推送至手机访问。
版权声明:本文由 果签工坊 发布,如需转载请注明出处。
本文链接:http://www.applep12.vip/technology/3neiT2ahadJSDWo.html