I hope this is a super simple question but for some reason i cant figure it out.
My requirement: Update data from excel to powerpoint.
I have many shapes in powerpoint slide (for better understand see image ppt.png) like Rectangle 1,Rectangle 5,Rectangle 3,
Rectangle 9,Rectangle 8,Rectangle 6 so on & Pentagon 1,Pentagon 5,Pentagon 3,
Pentagon 4,Pentagon 55,Pentagon 6 ...... which contains some text &
Graphic shape(Graphic 8,Graphic 7,Graphic 12,Graphic 5,Graphic 9)contains image.
I want to change/updates all text in shapes(Rectangle/Pentagon) & change images
in Graphic shape(Graphic 8,Graphic 7,Graphic 12,Graphic 5,Graphic 9) also.
For example:I want to change
see image:ppt.png
Shape(Pentagon 5) text ie "1 in 11" to "5 in 100";
Shape(Rectangle 3) text ie "Netflix" to "Hullu";
Shape(Graphic 12) image ie "Netflix.png" to "Hullu.png";
I have this type set [Shape(Pentagon 5)+Shape(Rectangle 3)+Shape(Graphic 12)] more than 30 ie
30X3=90 elements.Its very hard to update in powerpoint everytime.
NOTE:all shape has animation so I want any replace type command (mainly for image)
otherwise animation may be lost.
So I want to configure any micro/vba in excel(from where all data) that updates data in powerpoint.
May be it will be done by some array consept but cannot configure.
Bookmarks