sharepoint 2010 - How to show Document ID in an excel file cell? -


in sharepoint 2010 have document library. when create new document in library, document gets automatic document id. show document id in cel in excel file. these document id available property in excel file.

i have try macros below, didnt work document id property. other properties working fine . there solution?

enter image description here

i have tried these macros scripts:

public function getmycustomdocumentproperties(prop string) string     getmycustomdocumentproperties = thisworkbook.customdocumentproperties(prop) end function  public function getmybuiltindocumentproperties(prop string) string     getmybuiltindocumentproperties = thisworkbook.builtindocumentproperties(prop) end function 

error got in cell:

#value! 

this value of cel a4:

=getmycustomdocumentproperties("document id value")

this value of cel a5:

=getmybuiltindocumentproperties("document id value")

i found solution. was:

public function getmycontenttypeproperties(prop string) string     getmycontenttypeproperties = thisworkbook.contenttypeproperties(prop) end function 

Comments

Popular posts from this blog

html5 - What is breaking my page when printing? -

html - Unable to style the color of bullets in a list -

c# - must be a non-abstract type with a public parameterless constructor in redis -