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

On Thursday, November 5, 2009 9:12:09 AM UTC, TESBC wrote:
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...d-records.aspx