Forum Discussion

FrodeH's avatar
FrodeH
Copper Contributor
Dec 23, 2019

Can excel show content of document propery in a cell?

Can i get excel to do the same as word can with sharepoint metadata sync?   Specifically: Excel custom document properties on the info page. Can these be used in cells?
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Dec 23, 2019

FrodeH Only using a User Defined Function in VBA. Open the VBA editor and choose Insert, Module. Paste this code:

Function GetDocProp(DocPropertyName As String)
    GetDocProp = ActiveWorkbook.CustomDocumentProperties(DocPropertyName).Value
End Function

Now in any cell use the formula:

=GetDocPropr("NameOfCustomDocumentProperty")