The Solution

The solution to this problem is to employ automation in Excel that will automatically create the presentation based on data in your Excel workbook. Using VBA you can write code that will

♦ Create an instance of PowerPoint.

♦ Create an empty presentation using the designated template.

♦ Create a slide for each report you have created in Excel.

♦ Save the presentation to a location of your choosing.

Ideally, the only thing you'll need to do is add any content to the presentation that doesn't come from Excel.

0 0

Post a comment