Automatically showing the document's properties when it is opened

D

Dan

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
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top