?
Solved

Word 2007 Automation - Adding Multiple Tables using VBA

Posted on 2010-09-01
5
Medium Priority
?
2,565 Views
Last Modified: 2012-05-10
Hi all,

I'm trying to add multiple tables to a word document.  The first table works fine but I cannot get any further tables added properly... any help would be appreciated. Code is attached.  I assumed I would create a table then move to the end of the document then create another table etc.  


'*****EARLY BINDING
Dim objWord As Word.Application
Dim objDoc As Word.Document
Dim objTable As Word.Table
Dim objRange As Word.Range
'Create Word Instance
Set objWord = New Word.Application
'Create doc
Set objDoc = objWord.Documents.Add
objWord.Visible = True
objWord.Activate
'*****END EARLY BINDING -

'START TYPING
objWord.Selection.Font.Bold = True
objWord.Selection.TypeText "Projects"

objWord.Selection.TypeParagraph

'***Add Header

'***Add Projects*********************************************************************
rst.Open "SELECT Name, Start_Date FROM tblProject WHERE Plan_Year = 2010 AND FKEYProjectType=1 ORDER BY Name ASC", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
i = rst.RecordCount

'Create Table
Set objRange = objWord.Selection.Range
Set objTable = objDoc.Tables.Add(objRange, i + 1, 3)
'Setup Table properties
With objTable
    .AllowAutoFit = True
    .AutoFitBehavior wdAutoFitContent
    .BottomPadding = 0
    .TopPadding = 0
    .Rows.SetHeight 13, wdRowHeightExactly
    .Range.Font.Bold = False
'    .Columns(3).SetWidth 0.2, wdAdjustNone
End With

'Load Values into the table
objTable.Cell(1, 1).Range.InsertAfter "PROJECT NAME"
objTable.Cell(1, 2).Range.InsertAfter "START DATE"
With objWord.Selection.Font
    .Bold = True
    .Size = 9
End With

While Not rst.EOF
For x = 1 To i

    objTable.Cell(x + 1, 1).Range.InsertAfter x & ") " & rst.Fields("Name")
    objTable.Cell(x + 1, 2).Range.InsertAfter Nz(rst.Fields("Start_Date"), "NO START")

    rst.MoveNext

Next x
Wend
'ADD NEXT TABLE - Move to the end of the document to add the next table
objWord.ActiveDocument.Characters.Last.Select
objWord.Selection.Collapse
    With objRange
        .Collapse Direction:=wdCollapseEnd
        .MoveEnd
        .InsertParagraphAfter
        .Collapse Direction:=wdCollapseEnd
    End With
'***Add Road Construction
rst.Close
rst.Open "SELECT Name FROM tblVendor WHERE IsRoadSide = 1 ORDER BY Name ASC", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
i = rst.RecordCount

'Create Table
Set objTable = objDoc.Tables.Add(objRange, i + 1, 2)
'Setup Table properties
With objTable
    .AllowAutoFit = True
    .AutoFitBehavior wdAutoFitContent
    .BottomPadding = 0
    .TopPadding = 0
    .Rows.SetHeight 13, wdRowHeightExactly
    .Range.Font.Bold = False
'    .Columns(3).SetWidth 0.2, wdAdjustNone
End With

'Load Values into the table
objTable.Cell(1, 1).Range.InsertAfter "Road Side"
objTable.Cell(1, 2).Range.InsertAfter "Notes"
With objWord.Selection.Font
    .Bold = True
    .Size = 9
End With

While Not rst.EOF
For x = 1 To i

    objTable.Cell(x + 1, 1).Range.InsertAfter x & ") " & rst.Fields("Name")
    rst.MoveNext

Next x
Wend

Open in new window

0
Comment
Question by:CFrasnelly
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 33579080
Try:

objDoc.Application.Selection.TypeParagraph
Set objTable = objDoc.Tables.Add(objDoc.Application.Selection.Range, i + 1, 2)


Basically it does two things - adds a paragraph to disconnect from the previous table and replaces the ref to objrange which hasn't changed for the new table to be the end of the document where you placed the cursor.

Chris
'*****EARLY BINDING
Dim objWord As Word.Application
Dim objDoc As Word.Document
Dim objTable As Word.Table
Dim objRange As Word.Range
'Create Word Instance
Set objWord = New Word.Application
'Create doc
Set objDoc = objWord.Documents.Add
objWord.Visible = True
objWord.Activate
'*****END EARLY BINDING -

'START TYPING
objWord.Selection.Font.Bold = True
objWord.Selection.TypeText "Projects"

objWord.Selection.TypeParagraph

'***Add Header

'***Add Projects*********************************************************************
rst.Open "SELECT Name, Start_Date FROM tblProject WHERE Plan_Year = 2010 AND FKEYProjectType=1 ORDER BY Name ASC", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
i = rst.RecordCount

'Create Table
Set objRange = objWord.Selection.Range
Set objTable = objDoc.Tables.Add(objRange, i + 1, 3)
'Setup Table properties
With objTable
    .AllowAutoFit = True
    .AutoFitBehavior wdAutoFitContent
    .BottomPadding = 0
    .TopPadding = 0
    .Rows.SetHeight 13, wdRowHeightExactly
    .Range.Font.Bold = False
'    .Columns(3).SetWidth 0.2, wdAdjustNone
End With

'Load Values into the table
objTable.Cell(1, 1).Range.InsertAfter "PROJECT NAME"
objTable.Cell(1, 2).Range.InsertAfter "START DATE"
With objWord.Selection.Font
    .Bold = True
    .Size = 9
End With

While Not rst.EOF
For x = 1 To i

    objTable.Cell(x + 1, 1).Range.InsertAfter x & ") " & rst.Fields("Name")
    objTable.Cell(x + 1, 2).Range.InsertAfter Nz(rst.Fields("Start_Date"), "NO START")

    rst.MoveNext

Next x
Wend
'ADD NEXT TABLE - Move to the end of the document to add the next table
objWord.ActiveDocument.Characters.Last.Select
objWord.Selection.Collapse
    With objRange
        .Collapse Direction:=wdCollapseEnd
        .MoveEnd
        .InsertParagraphAfter
        .Collapse Direction:=wdCollapseEnd
    End With
'***Add Road Construction
rst.Close
rst.Open "SELECT Name FROM tblVendor WHERE IsRoadSide = 1 ORDER BY Name ASC", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
i = rst.RecordCount

'Create Table
objDoc.Application.Selection.TypeParagraph
Set objTable = objDoc.Tables.Add(objDoc.Application.Selection.Range, i + 1, 2)
'Set objTable = objDoc.Tables.Add(objRange, i + 1, 2)
'Setup Table properties
With objTable
    .AllowAutoFit = True
    .AutoFitBehavior wdAutoFitContent
    .BottomPadding = 0
    .TopPadding = 0
    .Rows.SetHeight 13, wdRowHeightExactly
    .Range.Font.Bold = False
'    .Columns(3).SetWidth 0.2, wdAdjustNone
End With

'Load Values into the table
objTable.Cell(1, 1).Range.InsertAfter "Road Side"
objTable.Cell(1, 2).Range.InsertAfter "Notes"
With objWord.Selection.Font
    .Bold = True
    .Size = 9
End With

While Not rst.EOF
For x = 1 To i

    objTable.Cell(x + 1, 1).Range.InsertAfter x & ") " & rst.Fields("Name")
    rst.MoveNext

Next x
Wend

Open in new window

0
 

Author Comment

by:CFrasnelly
ID: 33579145
That didn't work... although it did extend the first table?????
0
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 2000 total points
ID: 33579409
I had to remove references to the database to test it so hopefully I have re-instated it okay.  It works for me now in a practical test ... so see if this is different?

Chris
'*****EARLY BINDING
Dim objWord As Word.Application
Dim objDoc As Word.Document
Dim objTable As Word.Table
Dim objRange As Word.Range
'Create Word Instance
Set objWord = New Word.Application
'Create doc
Set objDoc = objWord.Documents.Add
objWord.Visible = True
objWord.Activate
'*****END EARLY BINDING -

'START TYPING
objWord.Selection.Font.Bold = True
objWord.Selection.TypeText "Projects"

objWord.Selection.TypeParagraph

'***Add Header

'***Add Projects*********************************************************************
rst.Open "SELECT Name, Start_Date FROM tblProject WHERE Plan_Year = 2010 AND FKEYProjectType=1 ORDER BY Name ASC", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
i = rst.RecordCount

'Create Table
Set objRange = objWord.Selection.Range
Set objTable = objDoc.Tables.Add(objRange, i + 1, 3)
'Setup Table properties
With objTable
    .AllowAutoFit = True
    .AutoFitBehavior wdAutoFitContent
    .BottomPadding = 0
    .TopPadding = 0
    .Rows.SetHeight 13, wdRowHeightExactly
    .Range.Font.Bold = False
'    .Columns(3).SetWidth 0.2, wdAdjustNone
End With

'Load Values into the table
objTable.Cell(1, 1).Range.InsertAfter "PROJECT NAME"
objTable.Cell(1, 2).Range.InsertAfter "START DATE"
With objWord.Selection.Font
    .Bold = True
    .Size = 9
End With

While Not rst.EOF
For x = 1 To i

    objTable.Cell(x + 1, 1).Range.InsertAfter i
    'objTable.Cell(x + 1, 2).Range.InsertAfter Nz(rst.Fields("Start_Date"), "NO START")

    rst.MoveNext

Next x
Wend
'ADD NEXT TABLE - Move to the end of the document to add the next table
objWord.ActiveDocument.Characters.Last.Select
objWord.Selection.Collapse
    With objRange
        .Collapse Direction:=wdCollapseEnd
        .MoveEnd
        .InsertParagraphAfter
        .Collapse Direction:=wdCollapseEnd
    End With
''***Add Road Construction
rst.Close
rst.Open "SELECT Name FROM tblVendor WHERE IsRoadSide = 1 ORDER BY Name ASC", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
i = rst.RecordCount

'Create Table
objDoc.Application.Selection.TypeParagraph
Set objTable = objDoc.Tables.Add(objDoc.Application.Selection.Range, i + 1, 2)
'Setup Table properties
With objTable
    .AllowAutoFit = True
    .AutoFitBehavior wdAutoFitContent
    .BottomPadding = 0
    .TopPadding = 0
    .Rows.SetHeight 13, wdRowHeightExactly
    .Range.Font.Bold = False
'    .Columns(3).SetWidth 0.2, wdAdjustNone
End With

'Load Values into the table
objTable.Cell(1, 1).Range.InsertAfter "Road Side"
objTable.Cell(1, 2).Range.InsertAfter "Notes"
With objWord.Selection.Font
    .Bold = True
    .Size = 9
End With

While Not rst.EOF
For x = 1 To i

    objTable.Cell(x + 1, 1).Range.InsertAfter x & ") " & rst.Fields("Name")
    rst.MoveNext

Next x
Wend

Open in new window

0
 

Author Comment

by:CFrasnelly
ID: 33579635
It works!!! With one strange bug (there's always something isn't there) ... It goes back and deletes almost the entire contents of the first cell in the first table....

Just figured it out... I needed to remove the below code... the .InsertParagraphAfter command was destroying it.  Thanks for your help on this Chris!!!

'objWord.Selection.Collapse
'    With objRange
'        .Collapse Direction:=wdCollapseEnd
'        .MoveEnd
'        .InsertParagraphAfter
'        .Collapse Direction:=wdCollapseEnd
'    End With
0
 

Author Closing Comment

by:CFrasnelly
ID: 33579637
Very helpful!!!!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is often necessary in this forum and others to illustrate Word fields as text with the field delimiters replaced with the curly brackets that the delimiters resemble when field codes are being displayed on the document. This means that the text c…
I'm writing to share my clumsy experience in using this elegant tool so you can avoid every stupid mistake I made. (I leave it to the authorities to decide if this deserves a place in the Knowledge archives.)  Now that I am on the other side of my l…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
Suggested Courses
Course of the Month8 days, 20 hours left to enroll

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question