Sub from_word() Dim objWrdApp As Object, objWrdDoc As Object Set objWrdApp = CreateObject("Word.Application") Set objWrdDoc = objWrdApp.Documents.Open("C:\Users\sysadmin\Desktop\CQR\CQR.docx") objWrdDoc.Range.Copy ActiveSheet.Paste objWrdDoc.Close False objWrdApp.Quit Set objWrdDoc = Nothing: Set objWrdApp = NothingEnd Sub
Sub from_word() Dim objWrdApp As Object, objWrdDoc As Object, objTbl As Object Set objWrdApp = CreateObject("Word.Application") objWrdApp.Visible = True Set objWrdDoc = objWrdApp.Documents.Open(ThisWorkbook.Path & "\CQR.docx") Range("A1").Select For Each objTbl In objWrdDoc.tables objTbl.Range.Copy ActiveSheet.Paste ActiveCell.Offset(objTbl.Rows.Count).Select Next objWrdDoc.Close False objWrdApp.Quit Set objWrdDoc = Nothing: Set objWrdApp = NothingEnd Sub
Sub from_word() Dim objWrdApp As Object, objWrdDoc As Object, objTbl As Object Set objWrdApp = CreateObject("Word.Application") objWrdApp.Visible = True Set objWrdDoc = objWrdApp.Documents.Open(ThisWorkbook.Path & "\CQR.docx") Range("A1").Select For Each objTbl In objWrdDoc.tables If objTbl.Rows.Count > 6 Then objTbl.Range.Copy ActiveSheet.Paste ActiveCell.Offset(, objTbl.Columns.Count).Select End If Next objWrdDoc.Close False objWrdApp.Quit Set objWrdDoc = Nothing: Set objWrdApp = NothingEnd Sub