Yes, it is handy to be able to automatically delete slides from a PowerPoint presentation There are instances, however, when it might be smarter to delete the content of a slide rather than the whole slide. What you can use in such cases is the VBA snippet below, which will loop through all slides of … Continue reading How do I delete all of a slide content but its title with VBA?
If you've decided that the logic of using Slide IDs to delete (or otherwise update) slides in a presentation is the way you'd like to proceed towards VBA coding your PowerPoint updates, you will undoubtedly need a handy way of deciphering the precise values of those Slide IDs that you have in your presentation. A super … Continue reading How do I show the Slide ID of a single slide?
One thing you're likely to discover when developing a robust approach for automatic updates is that you might have to come up with a way of scrapping the previous update and replacing it with the latest one. At least that's what I came to painfully realize a month after I fully coded my PowerPoint slides … Continue reading How do I only delete certain slides in a presentation?
A few of you asked me if there was anything specific in the separate saving procedure I would call at the end of my PowerPoint slides consolidation routine as well as what my reasoning for its inclusion in the code in the first place was. Well, I had several requirements: (1) The date when the … Continue reading How do I quickly save a presentation under a new name and file extension?
As a reporting analyst, part of my responsibilities involved compiling the monthly review slide deck for senior management Whilst it was not a difficult task, it was a pretty boring and time consuming one. Every month, I had to to compile 10 decks, each consisting of 70 slides, which had to be updated to show … Continue reading How do I quickly compile a single PowerPoint presentation from slides saved in multiple files?
What the heck is Excel Camera Tool? Excel's camera tool is a pretty handy button that allows you to make interactive pictures of your data! It comes especially handy when you need to copy Excel data that falls in non-adjacent ranges (since the camera tool generates an interactive picture, outline grouping can be used to … Continue reading How Do I Quickly Re-filter and Export Camera Tool Views to PowerPoint Slides?
Your articles on exporting Excel pivot tables to PowerPoint have come super handy but now I need to copy a bunch of charts... How do I tackle this? Before you continue, you'll need to keep a very important difference in mind - namely the one that VBA makes between chart sheets and chart objects • … Continue reading How Do I Quickly Export My Charts to PowerPoint Slides?