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.

Solution

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