i have excel document in sharepoint 2010 library. i need add excel properties that use values from sharepoint columns in excel cells. name of properties are in unicode text. on net i found next code
Function docprop(Info_needed As String) As Variant
Application.Volatile
DocPropCustom = ThisWorkbook.ContentTypeProperties(Info_needed).Value
End Function
when i use function DocPropCustom("Субјект ревизије") i receive value #value!. how i resolve this problem?
Function docprop(Info_needed As String) As Variant
Application.Volatile
DocPropCustom = ThisWorkbook.ContentTypeProperties(Info_needed).Value
End Function
when i use function DocPropCustom("Субјект ревизије") i receive value #value!. how i resolve this problem?