I have an Excel 2007 workbook that is part of a document library on
SharePoint. When I open the document, I have found that I have the ability to
view the metadata properties from the SharePoint site in the Excel workbook
itself, by going to the Office button, choosing "Prepare", then choosing
"Properties". One of the options is "Document Properties - Server", which
shows me all of the SharePoint properties for the document.

I'd like for these properties to automatically show, everytime someone opens
the document, as opposed to the user having to go to "Prepare -- Properties"
each time. Is there a way to do this?

Thanks for the help.

- Dan

If you want this in SharePoint refer to the appropriate forum..

In Excel you can add a macro to Workbook_Open event with a code like
For Each p In ActiveWorkbook.BuiltinDocumentProperties
Msg = Msg & p.Name & "=" & p.value & VBCrLf
Next
MsgBox Msg

"Dan" wrote:

I have an Excel 2007 workbook that is part of a document library on
SharePoint. When I open the document, I have found that I have the ability to
view the metadata properties from the SharePoint site in the Excel workbook
itself, by going to the Office button, choosing "Prepare", then choosing
"Properties". One of the options is "Document Properties - Server", which
shows me all of the SharePoint properties for the document.

I'd like for these properties to automatically show, everytime someone opens
the document, as opposed to the user having to go to "Prepare -- Properties"
each time. Is there a way to do this?

Thanks for the help.

- Dan