How do I embed SharePoint document properties in Excel 2007?

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:

On Monday, 30 June 2008 5:36 PM
Phil N wrote:

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/tutorials/aspnet/9b443d4a-0ec3-4599-be41-d4...c1fbd9b