|Say I have a powerpoint presentation with two slides.|
Slide 1 has an excel object embedded in it - not linked.
Slide 2 has a chart.
What VBA code would I need to modify the data source of the chart to point to a range on the excel object on slide 1.
chart.data = slide(1).Excel.Sheet("Year2014").Range("A1:C12")
chart.data = slide(1).Excel.Sheet("Year2013").Range("A21:C32")
The sheet name and range are not fixed.