Consulting

Results 1 to 2 of 2

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

Hybrid View

Previous Post Previous Post   Next Post Next Post
  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 sub
    Last edited by Aussiebear; 03-30-2023 at 04:08 PM. Reason: Added code tags to supplied code

  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
  •