none
How to update connections to charts that were made in excel using vba in Powerpoint RRS feed

  • Question

  • Hi guys,

    I'm trying to build a a vba code to update automatically the connections where the charts are connected. In excell it will be something like that:

    Private Sub Workbook_Open()
    Application.ScreenUpdating = False
    ActiveWorkbook.Connections("my_file").Refresh
    Application.ScreenUpdating = True

    ThisWorkbook.Save

    End Sub

    Which code should i write to do the same when my presentation is open?

    Thanks in advance

    Thursday, February 14, 2013 9:53 AM

Answers

  • Suppose your chart name is "Chart 3" is is in Slide 1 of activepresentation,then use below statement.

    ActivePresentation.Slides(1).Shapes("Chart 3").LinkFormat.Update


    Best Regards,
    Asadulla Javed, Kolkata
    ---------------------------------------------------------------------------------------------
    Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.

    • Marked as answer by Jose_Dionisio Thursday, February 14, 2013 3:15 PM
    Thursday, February 14, 2013 12:34 PM
    Answerer