Center Table in Word Through Excel

[Orion Cochrane]

I have an application in Excel that kicks out a report in Word. It is
basically one table with some data. What I would like is to center that table
on the page, but I cannot find how to do it through VBA. Although this is in
Excel, the properties I will need are from Word. So, when responding, please
preface your code with:

appWD.ActiveDocument

TIA.

 

[Jay Freedman]

I have an application in Excel that kicks out a report in Word. It is
basically one table with some data. What I would like is to center that table
on the page, but I cannot find how to do it through VBA. Although this is in
Excel, the properties I will need are from Word. So, when responding, please
preface your code with:

appWD.ActiveDocument

TIA.

appWD.ActiveDocument.Tables(1).Rows.Alignment = wdAlignRowCenter

 

[Orion Cochrane]

Big thanks. That was the last step in my reporting process. My application
will now be complete!