I have set up a chart in vb6 and have a word document that i want to paste it into. Using MSChart1.EditCopy puts two versions of it in the clipboard so when i do: WordDoc.EditPaste all i get is the row and column data and not the picture of the chart itself.
What command do i need to call to paste the graphic in rather than just the data. The menu option in word is: Edit->paste special and then selecting a graphic.
this is essentialy my code:
MSChart1.EditCopy
Set WordDoc = CreateObject("word.basic")
WordDoc.FileNew "c:\tester.dot"
WordDoc.EditPaste
WordDoc.AppShow
Ashley Cottle
AssureSoft
ashley.cottle@assuresoft.com