Replace chart in powerpoint from excel

This is what i have so far.
I'm now only having isses trying to get the charts to copy over to ppt.
let me know if i need to post under a new thread.


I like to use text in my templates that is %%string%% so that i know where to find and replace.
I have a shapes that has %%Chart1%%, %%chart2%%, etc. as the text in it. I'm trying to get it so that on sheet 2 of my excel book, where i have my charts in order, it will loop through the charts like it does with the text in sheet 1, and find the %%chart#%% in the powerpoint and paste my chart in there.
just fyi, sheet 1 has a word in column A and the replacement in column b - it loops through and edits the template accordingly.

Thanks for y'alls help.

Please Login or Register  to view this content.

I'd like to automate it so that i can fill in a large template with the charts i have in excel. The macro already finds and replaces text like %%employer%% with the employer name, so i'd like the macro to loop through the chart sheet and paste the charts where I need them.