To all MS Access Experts, I need your help in creating a multiple charts using Access, which I will also use in PowerPoint. To those who are confused as to what I’m trying to do, I want to write a routine that makes and updates charts in PowerPoint by using the data from Access queries. Please help me regarding this issue. Thanks a lot.
You can use try to use the program code provided below. You may get the MS Graph to display your own styling and include your personalize template. Make sure to back up your access database before proceeding to do the steps below.
Private Sub Command1_click()
Dim pwrpnt as Powerpoint.Application
Dim Presntation as PowerPoint.Presentation
Me.Graph0.Action = acOLECopy
Set pwrpnt = CreateObject(“Powerpoint.Application”)
Pwrpnt.Activate
Set Presentation = pwrpnt.Presentations.Open("TemplateFile.ppt")
pwrpnt.ActiveWindow.ViewType = ppViewSlide
pwrpnt.ActiveWindow.View.PasteSpecial ppPasteEnhancedMetafile
EndSub
Another automation procedure to create Graphs on Microsoft PowerPoint using Microsoft Access can be found here https://support.microsoft.com/en-us/help/200551. The programming code is a little bit longer than the first option.
