N/APosted on - 01/05/2012
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.
Create Charts in Access to be use in PowerPoint
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”)
Set Presentation = pwrpnt.Presentations.Open("TemplateFile.ppt")
pwrpnt.ActiveWindow.ViewType = ppViewSlide
Another automation procedure to create Graphs on Microsoft PowerPoint using Microsoft Access can be found here http://support.microsoft.com/kb/200551. The programming code is a little bit longer than the first option.