Macro to copy chart from Excel to word

  • Thread starter Thread starter Chris Parker
  • Start date Start date
C

Chris Parker

I need to write a macro that will select a chart from Excel and copy
it to a book mark in a word document.

Can anyone offer some help ?

Appreciate any reponse

Chris
 
Jon Peltier has some code to paste a chart into Word:

http://www.geocities.com/jonpeltier/Excel/XL_PPT.html#chartwd

You could replace precede this line:

' Paste chart at cursor position
WDApp.Selection.PasteSpecial Link:=False, _
DataType:=wdPasteMetafilePicture, _
Placement:=wdInLine, DisplayAsIcon:=False

with code that selects your bookmark, e.g.:

WDApp.Selection.GoTo What:=wdGoToBookmark, Name:="MyBkmk"
WDApp.Selection.PasteSpecial Link:=False, _
DataType:=wdPasteMetafilePicture, _
Placement:=wdInLine, DisplayAsIcon:=False
 
Back
Top