How to perisist object in Excel

[Dev]

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

[Tom Ogilvy]

I think you would have to write it out where it would be stored as data, then
read in the data and reconstruct the "object".

In any event, I doubt there is any built in support for it - you would have
to do all the work.

--
Regards,
Tom Ogilvy



"Dev" wrote:

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

[John.Greenan]

Dev,

What objects are you creating? Can you supply a bit more information? Tom
is probably right, but some objects can be persisted easily - such as
commandbars.

Post back with an answer and we can go from there.


--
www.alignment-systems.com


"Dev" wrote:

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

[Dev]

No it's not commandbars.....

Thanks!!

"John.Greenan" wrote:

> Dev,
>
> What objects are you creating? Can you supply a bit more information? Tom
> is probably right, but some objects can be persisted easily - such as
> commandbars.
>
> Post back with an answer and we can go from there.
>
>
> --
> www.alignment-systems.com
>
>
> "Dev" wrote:
>
> > 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!!

[Chip Pearson]

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" <[email protected]> wrote in message
news:[email protected]...
> 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!!

[Dev]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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!!
>
>
>

[Tim Williams]

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" <[email protected]> wrote in message news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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!!
> >
> >
> >