Can Access VBA control the lines drawn within a Word table or the way in which data is written to the Word table?

Please see attached Word doc. Access 2007 VBA is appending rows to the table’s columns 1 – 9.
Through VBA, can you control the lines being drawn and control how many cells are used for text? For example, ‘Passed’ spans 2 cells and I don’t want to see the line drawn between the 2 cells in this case.
In addition, I would like 'Report Findings (see Appendix A for details)' to span 6 columns without drawing lines in between the columns.

I am using the following code to append the text to the table: (Passed, Failed, Summary are then squished within these cells. Is there a way to have these span more than 1 cell?)
set rw = doc.Tables(1).Rows.Add
with rw
  .Cells(4).Range.Text="Passed"
  .Cells(6).Range.Text="Failed"
  .Cells(8).Range.Text="Summary"
end with
Doc1.docx
newbie46Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamMandenoCommented:
You need to use the Merge method to combine the cells.  Note that when you merge two cells, any cells to the right have to have their column number adjusted, so "Failed" goes in .Cells(5), not .Cells(6) after the Merge, etc:

  .Cells(4).Range.Text = "Passed"
  .Cells(4).Merge .Cells(5)
  .Cells(5).Range.Text = "Failed"
  .Cells(5).Merge .Cells(6)
  .Cells(6).Range.Text = "Summary"
  .Cells(6).Merge .Cells(7)

Best wishes,
Graham Mandeno [Access MVP 1996 - 2012]
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.