View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
prams prams is offline
external usenet poster
 
Posts: 1
Default 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