Okay this post is a old but for those that haven't worked it out and want to do it here are solutions as I was searching for sometime and finally worked this out.
All of these require you to create a visual basic module and work with Excel 2007. I haven't tested this with any other version so don't know if it will work or not.
Document Properties:
Function DocumentProperty(Property As String)
Application.Volatile
On Error GoTo NoDocumentPropertyDefined
DocumentProperty = ActiveWorkbook.BuiltinDocumentProperties(Property)
Exit Function
NoDocumentPropertyDefined:
DocumentProperty = CVErr(xlErrValue)
End Function
Custom Properties:
Function DocumentPropertyCustom(Property As String)
Application.Volatile
On Error GoTo NoDocumentPropertyDefined
DocumentPropertyCustom = ActiveWorkbook.CustomDocumentProperties(Property)
Exit Function
NoDocumentPropertyDefined:
DocumentPropertyCustom = CVErr(xlErrValue)
End Function
Sharepoint Properties:
Function DocumentServerProperty(Property As String)
Application.Volatile
On Error GoTo NoDocumentPropertyDefined
DocumentServerProperty = ActiveWorkbook.ContentTypeProperties(Property)
Exit Function
NoDocumentPropertyDefined:
DocumentServerProperty = CVErr(xlErrValue)
End Function
Phil N wrote:
How do I embed SharePoint document properties in Excel 2007?
30-Jun-08
I am able to embed document properties into a Word 2007 file but don't see
the equivalent for Excel. Surely it must be possible to embed SharePoint
metadata into a cell so that user of a spreadsheet don't have to cut & paste?
Thanks.
Previous Posts In This Thread:
How do I embed SharePoint document properties in Excel 2007?
I am able to embed document properties into a Word 2007 file but don't see
the equivalent for Excel. Surely it must be possible to embed SharePoint
metadata into a cell so that user of a spreadsheet don't have to cut & paste?
Thanks.
EggHeadCafe - Software Developer Portal of Choice
Finding Unmatched Records in Dataset Tables Using Linq
http://www.eggheadcafe.com/tutorial...1-d4454c1fbd9b/finding-unmatched-records.aspx