(Excel) Update a String Property in XMP

Demonstrates how to open a JPG or TIF image file, access the XMP metadata, and update the value of a string property. (If the string property does not already exist, it is created.)

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes 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.

success = xmp.LoadAppFile("qa_data/xmp/AJ_123642_1511.tif")
If (success <> True) Then
    Debug.Print xmp.LastErrorText
    Exit Sub
End If

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

' This example assumes that XMP metadata is already present in the image file.
If (xmp.NumEmbedded = 0) Then
    Debug.Print "No XMP metadata already exists.."
    Exit Sub
End If

' Get the XMP metadata.

Set xml = xmp.GetEmbedded(0)

' Show the XML:
Debug.Print xml.GetXml()

' Update (overwrite) a string property.
success = xmp.AddSimpleStr(xml,"NumberofTimes","123")

success = xmp.SaveAppFile("qa_output/updated.tif")
If (success <> True) Then
    Debug.Print xmp.LastErrorText
    Exit Sub
End If

Debug.Print "Success."