SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

SAS Addin for PowerPoint VBA SAS.Modify

Posts: 1

SAS Addin for PowerPoint VBA SAS.Modify

I'm looking to use VBA to modify an existing chart from the existing prompt value to another. I'm hoping to find the correct way to use the .modify action.

The example below allows me to identify which placeholder has my chart, but the use of the Modify action is incorrect.

Please let me know if you have any suggestions.

Thanks, Mark

Sub identifyobject()
    Dim sld As Slide
    Dim sh As Shape
    Dim sas As SASPowerPointAddIn
    Set sas = Application.COMAddIns.Item("SAS.PowerPointAddIn").Object

     If sh.Name = "Content Placeholder 6" Then
          sas.Modify "Prompt1" = "SomeOtherValue"
     End If
End Sub

Ask a Question
Discussion stats
  • 0 replies
  • 1 in conversation