What is it about the object you wish to store that can't be handled by storing its properties?
When you create the object and modifiy it you're modifying its properties: as long as you can capture those somehow then you can
re-create the object...

Maybe consider adding serialize/deserialize methods to your object if you need this.

--
Tim Williams
Palo Alto, CA


"Dev" wrote in message ...
Yes, I am storing some of my hidden data in custom doc properties (each field
in custom doc properties can be of length 255 chars...) but I also want to
store an object....

"Chip Pearson" wrote:

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