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