Extract data from Alt Text in PowerPoint presentation

[only412c]

Hi,

I am trying to extract the values or data within the ALT Text field in PowerPoint. Does anyone know how to code this in VBA?

This include pulling information from the Chart ALT Text fields as well.

 

[strongm]

One way:

[blue]Public Sub doit()
    Dim MySlide As Slide
    Dim myShape As Shape
    
    For Each MySlide In ActivePresentation.Slides
        For Each myShape In MySlide.Shapes
            Debug.Print MySlide.Name & ":" & myShape.Name & ":" & myShape.AlternativeText
        Next
    Next
End Sub[/blue]

 

[only412c]

Thanks strongm,

Some of the Alt Text do not pull such as in line text within bar charts. If the Alt Text is within the chart, how to handle the pull of these

 

[strongm]

I am not aware of 'in line' text within bar charts having any alternative text, but I am probably being dense.

Perhaps you can describe how you are creating such a thing?