Create Charts in Access to be use in PowerPoint

Asked By Angela Saizon 10 points N/A Posted 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.

• Status: Open
• Question Views: 1095
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Aristono Martin 20 points N/A #114367

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”)

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.

About Aristono Martin

Questions
3

Answers
370

Best Answers
53

• Vote Up 0 Vote Down

• Posted on - 01/06/2012
• Question Category: MS Access