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.
"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.