View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default How to perisist object in Excel

There several way you can store the properties of your object.
One would be to write the property values to worksheet cells,
perhaps on a hidden sheet. Another would be to store the
properties in defined names. Finally, you could store the
properties in custom document properties.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Dev" wrote in message
...
How to persist the object between different sessions within
Excel.

I am creating an application which is addin to Excel. When ever
I close
Excel application, I want to store the object that I created so
far - so
that, I can read it back when I reopen the same Excel file that
I closed
earlier. Is it doable using Excel OM?

Thanks!!