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!!