Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
Office GroupsView
Excel
Excel Charting
Excel Crashesgpfs
Excel Misc
Excel Newusers
Excel Programming
Excel Setup
Excel Worksheet Functions
Word Application Errors
Word Conversions
Word Customization Menustoolbars
Word Docmanagement
Word Drawing Graphics
Word International Features
Word Mail
Word Mailmerge Fields
Word Newusers
Word Numbering
Word Oleinterop
Word Pagelayout
Word Printingfonts
Word Setup Networking
Word Spelling Grammar
Word Tables
Word Visual Basica Addins
Word Visual Basica Customization
Word Visual Basica General
Word Visual Basica Userforms
Works Win
Office Developer Automation
Office Developer Com Add_Ins
Office Developer Officedev Other
Office Developer Outlook Forms
Office Developer Outlook Visual Basica
Office Developer Visual Basica
Office Misc
Office Setup
Officeupdate
Onenote
Outlook
Outlook Bcm
Outlook Calendaring
Outlook Contacts
Outlook Fax
Outlook General
Outlook Installation
Outlook Interop
Outlook Mac
Outlook Printing
Outlook Program_Addins
Outlook Program_Forms
Outlook Program_Visual Basica
Outlook Teamfolders
Outlook Thirdpartyutil
Project
Project Developer
Project Server
Visio
Visio Developer
Visio General
Word Visual Basica Beginners
Outlookexpress General
Office Communicator
Word Programming
Office Templates Misc

Group SummariesView
.NET Framework
Access
BizTalk
Certifications
CRM
DDK
Exchange Server
FoxPro
French
French .NET
Games
German
German .NET
Graphic Design
IIS
Internet
ISA Server
Italian
Italian .NET
Maps
MCIS
Miscellaneous
Mobile Apps
Money
MSN
Networking
Office
Ops Mgr
Publisher
Security
SharePoint
Small Business
Spanish
Spanish .NET
SQL Server
Systems Management Server
Transaction Server
Virtual PC / Virtual Server
Visual Studio
Win32
Windows 2000
Windows 2003 Server
Windows 7
Windows Live
Windows Media
Windows Update
Windows Vista
Windows XP
 

View All Microsoft Excel Misc Posts  Ask A New Question 

How do I embed SharePoint document properties in Excel 2007?

Phil N posted on Monday, June 30, 2008 5:36 PM

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.
reply

 

Solution

TESBC posted on Thursday, November 05, 2009 4:12 AM

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
reply


Previous Microsoft Excel Misc conversation.