Updating linked Charts automatically in Powerpoint when open

[KOLM#S]

Hi
I'm using the VBA below to open a Powerpoint presentation from Excel. I have created several charts in the presentation that source thier data from areas in the excel document. These charts are linked but I can only get them to update if I double click on each chart to reveal the hidden powerpoint data sheet......

Application.ScreenUpdating = False
Dim PowerPointApp As Object
Set PowerPointApp = CreateObject("PowerPoint.Application")
PowerPointApp.Visible = True
PowerPointApp.presentations.Open ("V:\Intelligent Board\PowerPoint 2006-07\PowerPoint April.ppt")
Application.ScreenUpdating = True[/code]

Is thier anyway of making these charts update automatically upon opening??????

MANY THANKS
KOLM#s

 

[Jon Peltier]

Try this:

PowerPointApp.presentations.Open "V:\Intelligent Board\PowerPoint 2006-07\PowerPoint April.ppt"
ActivePresentation.UpdateLinks

 

[KOLM#S]

Hi Jon

Many Thanks for your reply.... unfortuntely when i run the VB below it breaks down on the last line saying that I have not defined the variable.... I've had several attempts at definig a variable and failed miserablly!!!!! any chance you can advise??????


Dim PowerPointApp As Object
Set PowerPointApp = CreateObject("PowerPoint.Application")
PowerPointApp.Visible = True
PowerPointApp.presentations.Open "V:\Intelligent Board\PowerPoint 2006-07\PowerPoint April.ppt"
Activepresentations.UpdateLinks

Many Thanks
KOLM#s

 

[Jon Peltier]

1. ActivePresentation is singular
2. You need to reference it as PowerPointApp.ActivePresentation

 

[KOLM#S]

Hi Jon

Many thanks, that now runs without breaking down, however, I sill have to double-click on the chart in powerpoint to make it update?????

Any further suggestions on how to automate this?????

many thanks
KOLM#s

 

[Jon Peltier]

Here's a link to a search of the PowerPOint FAQ pages:

http://www.google.com/custom?q=upda...3b8;&domains=pptfaq.com&sitesearch=pptfaq.com