the code run from Excel opens a powerpoint template (potx), saves it as a pptx file then
gets the new path (since i do not know where and who will be using it), updates then breaks the links.
everything updates except for the two graphs - Chart1 and Chart 2
then i realized they are not 'Shapes'
what do i need for them to update?
thanks
.
.
.
gets the new path (since i do not know where and who will be using it), updates then breaks the links.
everything updates except for the two graphs - Chart1 and Chart 2
then i realized they are not 'Shapes'
what do i need for them to update?
thanks
.
.
.
Code:
For Each oPPTSlide In oPPTApp.ActivePresentation.Slides
oPPTSlide.Select
For Each oPPTShape In oPPTSlide.Shapes
oPPTShape.Select
If oPPTShape.Type = msoLinkedOLEObject Then
oPPTShape.LinkFormat.SourceFullName = Replace(oPPTShape.LinkFormat.SourceFullName, sOldPath, sNewPath)
oPPTShape.LinkFormat.Update
oPPTShape.LinkFormat.BreakLink
Else
End If
Next oPPTShape
Next oPPTSlide