Hi,
I am a VBA rookie and I am still learning the very basics of VBA at the moment.
My question/problem is that how do I copy a chart from Excel and paste it into a placeholder on powerpoint using a marco.
The code below works fine for copy and paste the chart from Excel to powerpoint, but it doesnt paste it into the placeholder, I am just wondering how should the code be amended in order to paste it into a placeholder.
Below is more information on the problem
Excel
Spreadsheet name: Report generator
Spreadsheet location: (Already activate)
Worksheet: Summary
Chart name: Chart 1
Powerpoint
Powerpoint name: report
powerpoint locationL (already activate)
Slide: P.3
Placeholder position: the one of the left, I am not sure whether there is a name for the placeholders on powerpoint (there are two placeholders on P.3, one on the right, the other one on the left)
Thank you very much!
Bookmarks