Forum Discussion
Dynamically update metadata from a cell
Hi, In excel I've created a link between a cell and custom properties. The value is dynamically updated in custom properties: How ever it is only created once in the files metadata...
I’ve the exact same question as well. Would love to understand what a fix could be . 😀
- I had a similar problem so I used VBA to run and save on closing the file.
"Sub Auto_Close()"
Remove the quotes and replace the names in below
ActiveWorkbook.ContentTypeProperties("Your_Metadata_Name").Value = Range("Your_Cell_Value_In_Excel_File").Value
Above will update the Metadata.
ActiveWorkbook.Save
End Sub
You may need to tweak the save part depending on your setup. Your columns should now update according to your metadata.
