Thread: [Solved] Updating/Format Objects
View Single Post
 
Old 01-22-2015, 12:42 AM
Guessed's Avatar
Guessed Guessed is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,980
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

It would be a lot easier to resize the chart original in Excel. If the size is important, you may be able to duplicate the chart on a hidden worksheet in the same workbook where you can resize the chart and then use that version to paste into Word.

Assuming that you can't do that, the next easiest option would be to bookmark each of the graphics so you don't need to query the field code values. If this was done, the following code could be adapted to work.
Dim aPic As InlineShape
Set aPic = ActiveDocument.Bookmarks("Chart1").Range.InlineSha pes(1)
With aPic
.Width = 400
.Height = 200
End With
Reply With Quote