-
Resize Chart as Picture
Hey guys.. I'm copying over a chart object (as a picture) into a word bookmark and resize the picture. I can copy the chart as a picture no problem, just can't figure out how to resize (as a picture). I want to leave the actual chart alone. Any ideas?
[VBA]
ThisWorkbook.Sheets("Trend Charts").ChartObjects("Chart2").CopyPicture
'Somehow resize the image in the clipboard
pappword.Selection.Goto Name:="CHART_WATCH"
pappword.Selection.Paste
[/VBA]
I'm pretty sure that I need to set the picture as a variable and edit it that way, but the above is the only way I know how to copy the chart as a picture. Thanks for any help you can give me!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules