software

Hi all,

May I ask whether some of you have experience of implementing object
persistence inside Excel? Can you help me by providing me some
reference?

Thanks a lot.TomHi,

I presume you are talking about persisting instantiated class modules.

The workbook has a Thisworkbook code module attached into which you can add
private variable declarations (which could be of the type of your class
module) amp; public accessors for these (property get/set/let).

You could use your Workbook_Open (in the Thisworkbook code module), or
similar, to instantiate this amp; can the refer to as Thisworkbook.XXXX in your
code (where X is the name of your property get/set/let etc).

I've used this to cache XML (rss/webservice) data inside an XLA (that then
exposes functions that other spreadsheets can use) - I don't have the code to
hand but it sounds like what you are trying to do drop me a mail amp; I can dig
it out.

Thank amp; regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Masterquot;Tom Chauquot; wrote:

gt; Hi all,
gt;
gt; May I ask whether some of you have experience of implementing object
gt; persistence inside Excel? Can you help me by providing me some
gt; reference?
gt;
gt; Thanks a lot.
gt;
gt;
gt; Tom
gt;
gt;

Hi Chris,

Thanks a lot for your information. I will make a trial some point in
the near future.

Tom