Store custom doc properties Temporarily ?
 

Hi,

I want to add a custom document property temporarliy. I mean I want to
add it only for an instance of workbook. The custom document property
should get destroyed when the instance of the workbook is closed.
Please let me know on this.


I know I can avoid the warning message Box by doing this.
bSavedPropVal = currExl.Saved
currExl.CustomDocumentPropeties("custom").Value = 1
currExl.Saved = bSavedPropVal


Rgds/Pramoda Jois