break powerpoint links to excel

[almagg]

i have a powerpoint template linked to excel.
each month an excel program is run to update the workbook.
at the end i have it open the ppt template which updates the presentation.
then i save it as a regular ppt presentation.
BUT i want to break the links before saving.

thanks

 

[almagg]

got it.
there seemed to be a lot of complicated solutions when i did a web search.
then i just tried the obvious and it worked.


For Each objPPTSld In objPPTApp.ActivePresentation.Slides
For Each objPPTShp In objPPTSld.Shapes
If objPPTShp.Type = msoLinkedOLEObject Then
objPPTShp.LinkFormat.BreakLink
End If
Next objPPTShp
Next objPPTSld