2010-06-15, 13:27 #1
- Join Date
- Mar 2003
- Elkins Park, Pennsylvania, USA
- Thanked 0 Times in 0 Posts
Hi. I hope this is a simple question: What is the property (or collection) in a document that corresponds to the fields/columns in the document's SharePoint Library that are exposed via the drop-down list in Insert: QuickParts > Document Properties? (I simply want to iterate through them to validate the values they already store.)
Using a quick and dirty "For/Next" routine, I've ruled out the BuiltInDocumentProperties and the CustomDocumentProperties collections, because they don't list the fields shown in Document Properties - Server panel. (Interestingly, I tried to record the act of inserting one of the quickparts/properties, and got a conspicuously Watergate-like empty recording!)
As always, thanks in advance for your help!<font face="Comic Sans MS">That's what you do in a herd; you look out for each other!</font face=comic> - Mike
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2010-06-15, 20:02 #2
- Join Date
- Jan 2001
- Melbourne, Victoria, Australia
- Thanked 139 Times in 132 Posts
I don't see the server panel on my machine (no Sharepoint) so I can only offer a suggestion. I would have looked in the two places you said failed so we will need to get more inventive to work out where the metadata lives.
Try changing the docx filename to end in .zip and then search through each of the xml files contained within for the text you are looking for - I would search for the server name that you see in the document assuming that name is unlikely to appear anywhere else in the document. If you find it, what xml document is it in and what tag/attributes appear to contain it?Andrew Lockton, Chrysalis Design, Melbourne Australia