Hi,

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) & public accessors for these (property get/set/let).

You could use your Workbook_Open (in the Thisworkbook code module), or
similar, to instantiate this & 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 & I can dig
it out.

Thank & regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"Tom Chau" wrote:

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.


Tom