I am new to the VBA language. This code works to open and save a power point 2007 presentation that is linked to Excel 2007 but not sure what the best approach is to update the link. If the presentation is set to automatic it will update the links. The problem is I don't want the saved new name to have the message pop up to update links.

Being new to VBA I don't know where the break link should be or the proper code to update links if the pptx presentation was changed to manual update.
Can anyone please help??
Thanks much

[code]
Sub Open_PowerPoint_Presentation()
'Opens a PowerPoint Document from Excel

Dim objPPT As Object

Set objPPT = CreateObject("PowerPoint.Application")
objPPT.Visible = True

objPPT.Presentations.Open "\\sydata2\common$\CTS\MonthlyReports\Carrier\Carrier Monthly Report.pptx"

'Update Link and Save Document to another name'
On Error GoTo 0

objPPT.activepresentation.UpdateLinks
objPPT.activepresentation.SaveAs "\\sydata2\common$\CTS\MonthlyReports\Carrier\Carrier Monthly ReportTSTZ.pptx"
objPPT.Quit

End Sub
[\code]