Consulting

Results 1 to 2 of 2

Thread: Edit Data in Word Chart - Activate Chart Data Window not working

  1. #1
    VBAX Newbie
    Joined
    Aug 2019
    Posts
    2
    Location

    Edit Data in Word Chart - Activate Chart Data Window not working

    I am looking to open the Edit Data excel table in a Word Chart to update the information for multiple charts in the document. I am looking to loop through all shapes in the document or I could call a chart using it's title too.

    This is what I have so far and it just loops through the document and does nothing:

    Sub ChartsUpdate()
    '
    '
    Dim objShape As InlineShape
    For Each objShape In ActiveDocument.InlineShapes
    If objShape.Type = wdInlineShapeChart Then
    objShape.Chart.ChartData.ActivateChartDataWindow
    End If
    Next

    End sb

  2. #2
    VBAX Newbie
    Joined
    Aug 2019
    Posts
    2
    Location
    Hi everyone, I am still having issues with this. Anyone have any ideas?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •