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.