How do I embed SharePoint document properties in Excel 2007?

  • Thread starter Thread starter Phil Ny
  • Start date Start date
P

Phil Ny

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.
 
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
 
Hi have a situation where updating list column in sharepoint need to update the excel custom properties, no clue where what needs to be done....... any help will be greatfull.

Thanks
Murali.P
 
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.
Click to expand...

Hi Phil,

I am using excel2010, need got the same requirement as on updating the library column values need to update in excel custom property.............. could you please let me know the steps needs to follow........

any code sample will great help here

Murali.P
 
Back
Top