Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh linked Custom Document Properties before save.
I am using MOSS 2007 to house a document library for Excel based finance
documents. In order to ue some of the features of MOSS 2007, I have promoted several Custom document Properties to become columns in the document library. After a filename has been chosen on the SharePoint library, a SharePoint triggered dialogue box opens showing all of the Columns that require values. At present, these values are only correctly filled out if you visit file,properties before saving. I've tried using the workbook_beforesave function to cycle through the customdocumentproperties collection, dumping them into the intermediates window for now to refresh them, however they retain the old values during the first save, and then the correct values if you click save once more. Other posts on this forum suggest that this is due to the fact that Custom Properties don't get flushed until me.save or similar is fired, however I can't do that until the Properties have been set in the SharePoint window. I'd rather not replace the linked properties with programatically added ones as it will increase the overhead on development considerably as we have a large number of columns that are promoted. Why wasn't there a refresh method included in customdocumentproperties for linked props? Any ideas? Paul. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as mhtml loses custom document properties. | Excel Programming | |||
Save As MHTML loses custom document properties. | Excel Programming | |||
dont see custom document properties... | Excel Programming | |||
How can I using Excel custom document properties in the header? | Excel Worksheet Functions | |||
Accessing custom document properties | Excel Programming |