Create Charts in Access to be use in PowerPoint

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #114367

Create Charts in Access to be use in PowerPoint

qa-featured

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 http://support.microsoft.com/kb/200551. The programming code is a little bit longer than the first option.

Login/Register to Answer

Related Questions