Yes, you can use VBA to do this. I’ve written the code to build slides based on data in Excel, and all I have to do is press the button in Excel. I have several custom functions that help. If you just want to build the slides directly in PowerPoint, you would use ADO to create a record set that retrieves the data you want and then loop through the recordset to generate the slides and any hyperlinks that you want. It’s not a very easy process any more now that Microsoft removed macro-creation from PowerPoint. I’ve had success creating the slides in Excel and then using the Immediate Mode to identify objects and values associated with the slides.
