The previous week a friend of mine asked me for a favor. He told me that he spends a lot of time copying Excel charts (as pictures) to Power Point presentations. The problem was that he had some really large workbooks that contained experimental results. Each workbook had more than 20 charts, so the procedure of “copy – paste special” was really time-consuming (and boring). He wanted from each workbook to create a new presentation and in every slide to include a text box with the chart title and the chart itself as picture.
My solution to his problem was the code that you will find below. The code loops in every sheet and tries to find embedded charts. Afterwards, it loops in chart sheets. Whenever a chart is found, is copied and is inserted as a picture to a new power point slide.
VBA code
How to use it
The short video below demonstrates the VBA code in use.
Download it from here
The zip file contains three files, one for each office version (2003, 2007 & 2010). Each file has already a reference to the corresponding Power Point library. Just remember to enable macros before using them.
Read also
Resize A Picture During A Presentation
Arrange All The Pictures Of A Presentation
