Embed workshet into powerpoint using vba excel 2013

Hi all,

I hope someone can help me please.

I have charts in excel and I would like to export them into a powerpoint slide using VBA. I can do this fine as a picture.
However I would like to have the ability to format it within powerpoint and also to change the data BUT not have it linked to the source data.

Essentially have the same ability to do everything I can if I opened ppt and did 'insert chart' but copying and pasting it from the pre-existing chart in my excel workbook.

I hope this makes sense?

To put this need in context:

• I have excel workbooks with standard charts in them.

• If someone wants to replicate this in ppt they current insert chart, format again and copy and paste the data - totally inefficient.

• However having it link to the source data wouldn't work as someone on a train / aeroplane may need to edit the data / format and they wouldn't have access to the source data. Plus having the link is too risky as people may not understand the full consequences of what they are changing.

Thanks for your help in advance.

Can you show your code? At least the part that copies the chart and pastes it as a picture in PP.

I'm not sure how you want to select the charts. This uses the ActiveChart in Excel. So select a chart before running the procedure.

Please Login or Register  to view this content.

You're welcome. Thanks for the feedback.