mg25683
04-04-2018, 12:33 AM
21969
I would like to paste a NOT linked chart from excel to a power point slide.
I am not sure how the pastespecial option is called in english (probably something like "keep source formatting and embed the worksheet")
I use
(...).chartObject.chart.ChartArea.copy
(...).slide.Shapes.PasteSpecial(ppPasteShape, link:=msoFalse)
but the ppPasteDataType enum members do not correspond with what i see in the UI and the "link" param doesn't seem to do anything - the chart is linked regardless of its value.
Any advice?
I would like to paste a NOT linked chart from excel to a power point slide.
I am not sure how the pastespecial option is called in english (probably something like "keep source formatting and embed the worksheet")
I use
(...).chartObject.chart.ChartArea.copy
(...).slide.Shapes.PasteSpecial(ppPasteShape, link:=msoFalse)
but the ppPasteDataType enum members do not correspond with what i see in the UI and the "link" param doesn't seem to do anything - the chart is linked regardless of its value.
Any advice?