Can you also make PowerPoints of your analyses for us, so that we can directly use them for our meetings?
As much as I like getting new responsibilities, it would be a stretch to say I was jumping with joy at the prospect of spending a good hour or two on the mind-numbing activity of making screenshots of my Excels and pasting them in PowerPoint.
So, I went about seeking a way of doing it quickly and efficiently. Naturally, automation was the first approach that came to mind.
If you’re facing a similar hurdle, don’t panic – there’s a neat way around it!
You can easily use Excel’s VBA environment to copy your Excel content, call the PowerPoint application and paste it there.
My task at hand involved re-filtering the pivot table placed on a particular sheet about 10 times and copying its content after each re-fitlering on a set slide in a pre-defined PowerPoint presentation.
The code below does exactly this.
Naturally, because it was developed for such a specific case, most of it will have to be re-written to fit the requirements of any other scenario. What is directly transposable, however, is the bit that calls the PowerPoint environment in the beginning.
Most importantly, you need to make sure that the Microsoft PowerPoint Object Library is invocable from Excel by enabling the reference in Excel VBE Editor
Happy VBA coding!