The following is a generalization of a routine I have been using for at least a decade. I designed it so it could be installed in any Excel spreadsheet and everything is user customizable.
I had a PowerPoint presentation that linked back to an Excel spreadsheet. The problem was that the spreadsheet was huge and took a lot of time to open. So when it came time to update links, PowerPoint opened the file, did the update, closed the file, moved onto the next link, opened the file ... In fact, we had to babysit the process since PowerPoint would move onto the next link and attempt to open the file before it had closed from the previous link.
So I had to come up with a method that, instead of pulling from Excel, the process was pushed to PowerPoint. The old process took over an hour. The new process took less than a minute. It also turned out to be more flexible with things like named dynamic ranges.
The ZIP file contains documentation and a demonstration (run the test macro). However, it has a module ModXL2PP that can be downloaded as a BAS file and imported into any macro-enabled spreadsheet of your choice. With this module in place, you can place charts, tables and replace text into a preformatted PowerPoint presentation.
Bookmarks