Brand new programmer here! I'm currently working on a macro in Excel that will open up an MS Word document and input data from Excel.
Part of the data pull from Excel includes a formatted table. I have figured out how to insert the table into MS Word at the correct place in the document using a bookmark, but unfortunately can't figure out how to get the table to center itself. Any suggestions? My bookmark in MS Word is centered but the table is still inserted left justified. Relevant code section is below.
.Selection.Goto What:=wdGoToBookmark, Name:="Chart"
.Visible = True