VBA code to Format Word Tables though Excel

rasika99 · Sep 16, 2014

I have some tables in a Excel file. There is a VBA code to copy there tables to a Word Document View attachment Book2.xlsm. However, height of the rows are higher than required when tables are copied.

can i reduce the height of the rows in word document by changing existing VBA Code?

WizzardOfOz · Sep 18, 2014

Try Google

from http://msdn.microsoft.com/en-us/library/office/ff197905(v=office.15).aspx

Code:

     Set newDoc = Documents.Add 
     Set aTable = newDoc.Tables.Add(Range:=Selection.Range, NumRows:=3, NumColumns:=3) 
     aTable.Rows.SetHeight RowHeight:=InchesToPoints(0.5),   HeightRule:=wdRowHeightExactly

also see http://msdn.microsoft.com/en-us/library/office/ff193659(v=office.15).aspx

VBA code to Format Word Tables though Excel

rasika99

New member

WizzardOfOz

New member