Copy and Paste an Excel Chart into PowerPoint with VBA

Creating Powerpoint presentations automatically is handy if you want the power to control another office application. In this post I will copy a chart in Excel and paste it into a fresh instance of Power Point. I will show two examples, once where the data will be pasted into a presentation with a title and one without. This is a building blocks approach, creating a procedure which pastes one chart might seem like time better spent done manually but if there were 20 charts it would be faster for VBA to do the work for you.

Tags Excel, vba, powerpoint, chart