Hi all,
I'm learning to use Sharepoint right now... one thing that would be very useful to me is the ability to insert column data into a spreadsheet.

In Word you can do this with Insert > Quick Parts > Document Property.

How can this be accomplished in Excel? I have seen some google information about creating a user defined function "GetProperty" but haven't been able to make it work for whatever reason. I found the (very very long) code here: http://bit.ly/9g58Ah

Here is a second, much shorter tidbit of code which I also cannot get to work:
Function DocumentServerProperty(Property As String)
Application.Volatile
On Error GoTo NoDocumentPropertyDefined
DocumentServerProperty = ActiveWorkbook.ContentTypeProperties(Property)
Exit Function

NoDocumentPropertyDefined:
DocumentServerProperty = CVErr(xlErrValue)
End Function
Found here: http://bit.ly/bTi4Tj

I'm pretty sure the reason I can't get it to work is (1) because some piece of code needs to be edited to tell it to look at SharePoint Server content type properties and (2) I am trying to execute the function improperly within the spreadsheet.

I have never done UDFs before so please be patient with me! Thanks in advance!

x-posted in General Forum on 21 July 2010
http://www.excelforum.com/excel-gene...cel-sheet.html