Thank you for your replies.
gmayor, I used your code, I can get it to work however it is still creating the tables regardless of if the excel data is blank. The way I have the tables set up is:
Objective 1
Heading: l Excel Data enter here
Heading: l Excel Data enter here
Heading: l Excel Data enter here
So with your code I have changed it to:
Code:
Sub Example()
Dim AppWord As Object
Dim WordDoc As Object
Dim oTable As Object
Dim oRng As Object
Dim oCell As Object
Dim ExcSheet As Excel.Worksheet
Dim i As Integer
On Error Resume Next
Set AppWord = GetObject(, "Word.Application")
If Err Then
Set AppWord = CreateObject("Word.Application")
End If
On Error GoTo 0
AppWord.Visible = True
'Set WordDoc = AppWord.Documents.Add("C:\Path\DocName.docx")
Set WordDoc = AppWord.activedocument
'Set a range to the table before the place to insert a new table
Set oRng = WordDoc.Tables(7).Range
'collapse the range to its end
oRng.collapse 0
'Add an empty paragraph to the range
oRng.Text = vbCr
'Collapse the range to the end of the empty paragraph
oRng.collapse 0
'and add a table at the range
Set oTable = WordDoc.Tables.Add(Range:=oRng, NumRows:=10, NumColumns:=2)
'Now fill the table
Set oCell = oTable.Cell(1, 1).Range 'Row,Column
oCell.End = oCell.End - 1
oCell.Text = "Objective 1"
Set oCell = oTable.Cell(1, 2).Range
oCell.End = oCell.End - 1
oCell.Text = ""
Set oCell = oTable.Cell(2, 1).Range 'Row,Column
oCell.End = oCell.End - 1
oCell.Text = "Heading:"
Set oCell = oTable.Cell(2, 2).Range
oCell.End = oCell.End - 1
oCell.Text = Excel Textbox.Value
'Set oRng to oTable.Rang
'and repeat the above section for each new table depending on the coindition that determines whether a table is required.
End Sub
When I press the command button it still creates the tables regardless of if the boxes in excel are blank or have text in. Am i doing something wrong?