Power Point Automation Template | Automation Database

Function for using PowerPoint Automation

PowerPoint Automation is a very powerful technique where you can communicate with a PowerPoint document from within VBA code in your Access Project. This allows you to do some very powerful things, such as populating an existing presentation with data from your database, taking advantage of PowerPoint documents you've already setup, dump data into a presentation and format it and a wide variety of other uses. The function below shows a very simple example of how to interact with PowerPoint from within your Access Application.

Public Function doPowerPointAutomation() On Error GoTo doPowerPointAutomationErr Dim strTemplateFile As String Dim strFileName As String strTemplateFile = Application.CurrentProject.Path & "\MyExistingPPTFile.ppt" strTemplateFile = Application.CurrentProject.Path & "\MyNewPPTFile.ppt" Dim ppt As New PowerPoint.Application Dim pptPresentation As PowerPoint.Presentation With ppt .Visible = True .WindowState = ppWindowMinimized '***set the presentation & slide to the template that was passed in Set pptPresentation = .Presentations.Open(strTemplateFile) With pptPresentation pptPresentation.Slides(2).Delete pptPresentation.SaveAs strFileName '***open the folder Shell "explorer.exe " & strFileName, vbNormalFocus '***close the ppt pptPresentation.Close End With '***clean up object Set pptPresentation = Nothing End With '***close PowerPoint & clean up object ppt.Quit Set ppt = Nothing doPowerPointAutomationExit: Exit Function doPowerPointAutomationErr: MsgBox Err.Description, vbOKOnly, Err.Source & ":" & Err.Number Resume doPowerPointAutomationExit End Function

Live Demonstration: To experience a more interactive and personalized demonstration of this WSI template, we invite you to contact WSI and schedule a live demonstration with one of our team members. This opportunity allows you to engage directly with us, either as an alternative to or in conjunction with downloading and exploring the demo version of the template at your leisure. Please note that downloading Microsoft Office files, including Microsoft Access database files, might trigger a security warning on your computer. To avoid this and get a comprehensive overview, you have the option of viewing the template through a virtual meeting on Teams or Zoom with a WSI representative.
Once you purchase the database template, you will receive the full version of the database in a standard Access Database file. The purchased database will have full access to the database window, all design objects, the visual basic project code, and you will be able to modify or add to the design in any way you wish (this does not apply to the run-time/compiled versions). If you lack the time to integrate this database into your system, please Contact Us and we will be glad to help with your integration process. If you like the basics of what you see in the database, but need enhancements to make the system functional for your business, please Contact Us and we will develop a quote for you to implement the additional features and enhancements that you require.

$24.99 - this allows you to use this database template however you wish within your organization.

Once your purchase is complete - you will receive an email with a link to download the full version of the database.

If you need any help implementing this function or modifications made for your needs, please Click Here to get a free quote for your Microsoft Access Development needs. 

Click Here to learn more about the WSI quoting process.

Be sure and check out our other Power Point Automation Template Databases:

The Power Point Automation Graph Database shows you how to take a graph object inside your access database and insert it into your powerpoint presentation. Click Here to learn more about the Power Point Automation Graph Database.

The Power Point Automation Report Database shows you how to take a report object inside your access database and insert it into your powerpoint presentation. Click Here to learn more about the Power Point Automation Report Database.