View Single Post
 
Old 10-15-2014, 11:14 AM
jon12355 jon12355 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Oct 2014
Posts: 5
jon12355 is on a distinguished road
Default

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?
Reply With Quote