(Excel) XMP Array Property - Bag, Seq, or Alt

How to insert or update an XMP array property (bag, seq, or alt).

Download Excel Class Modules Chilkat Excel Class Modules

' This requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim xmp As Chilkat.Xmp
Set xmp = Chilkat.NewXmp

' Load a JPG or TIF image file.
' Sample JPG's with XMP metadata may be found at:
' http://www.chilkatsoft.com/testData/xmp/sample1.jpg
' http://www.chilkatsoft.com/testData/xmp/sample2.jpg
' http://www.chilkatsoft.com/testData/xmp/sample3.jpg

success = xmp.LoadAppFile("sample1.jpg")
If (success <> True) Then
    Debug.Print xmp.LastErrorText
    Exit Sub
End If

Debug.Print "Num embedded XMP docs: "; xmp.NumEmbedded

' Assuming there is at least one, get the 1st.
' (There is typically never more than one, but theoretically it's possible.)

Set xml = xmp.GetEmbedded(0)
If (xmp.LastMethodSuccess = True) Then

    ' Create an object to hold one or more string values.
    Dim sa As Chilkat.StringArray
    Set sa = Chilkat.NewStringArray
    success = sa.Append("value_1")
    success = sa.Append("value_2")
    ' ...

    success = xmp.AddArray(xml,"bag","Iptc4xmpCore:Chilkat",sa)
    If (success <> True) Then
        Debug.Print xmp.LastErrorText
    Else
        ' Save the JPG.
        success = xmp.SaveAppFile("modified.jpg")
        If (success <> True) Then
            Debug.Print xmp.LastErrorText
        End If

    End If

Else
    Debug.Print xmp.LastErrorText
End If