(Excel) Get a Structure Property Value from XMP

Demonstrates how to open a JPG or TIF image file, access the XMP metadata, and fetch the value of a structure property, such as the Iptc4xmpCore:CiTelWork (found within the Iptc4xmpCore:CreatorContactInfo structure).

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


    propVal = xmp.GetStructValue(xml,"Iptc4xmpCore:CreatorContactInfo","Iptc4xmpCore:CiTelWork")
    If (xmp.LastMethodSuccess <> True) Then
        Debug.Print "Not found."
    Else
        Debug.Print propVal
    End If

Else
    Debug.Print xmp.LastErrorText
End If