Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Setting Class Collections & their Contents to Nothing.

Hi Everybody

I would like to check something out that I'm a little wooly on. I
have a project, and when finishing, the code sets the collection
objects and their contents to Nothing. My query is this; if there are
two class collections, A and B, and a number of objects {C} which can
belong to A, B, or A and B, is there a proper order for setting to
Nothing A, B, and {C} ? The reason for my wooly headedness is that I
am not entirely certain what constitutes a Parent-Child cross-
referenced association, and therefore what to do in that case. I'm
half certain this isn't such a case, but I don't really know.

If you can offer me some advice, ideally by way of an exmple, I would
appreciate it.

Regards

chatterbox

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Setting Class Collections & their Contents to Nothing.

A and B hold references to C. Even when set to nothing, the variable
continues to exist. Setting A or B to nothing does nothing to the things
referenced in its collection. Setting C to nothing does nothing to the
references held within the A and B collections. There is no parent-child
relationship as I understand your description.

--
Regards,
Tom Ogilvy


"chatterbox" wrote:

Hi Everybody

I would like to check something out that I'm a little wooly on. I
have a project, and when finishing, the code sets the collection
objects and their contents to Nothing. My query is this; if there are
two class collections, A and B, and a number of objects {C} which can
belong to A, B, or A and B, is there a proper order for setting to
Nothing A, B, and {C} ? The reason for my wooly headedness is that I
am not entirely certain what constitutes a Parent-Child cross-
referenced association, and therefore what to do in that case. I'm
half certain this isn't such a case, but I don't really know.

If you can offer me some advice, ideally by way of an exmple, I would
appreciate it.

Regards

chatterbox


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Setting Class Collections & their Contents to Nothing.

With the uncertainty of any parent-child associations put to rest, I
can close out all of the class objects in the usual way.

Thanks Tom


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting a collection in a class J Streger Excel Programming 3 May 8th 07 09:13 PM
Setting a Custom Class as a Global variable Xiazer[_15_] Excel Programming 3 May 31st 06 11:52 AM
Problems Setting properties of class module Andibevan[_4_] Excel Programming 2 October 2nd 05 01:44 PM
Class Module for setting Automatic Calc GregR Excel Programming 6 May 6th 05 12:21 AM
Setting the Values Property of the Series Class Alex A Excel Programming 2 January 30th 04 08:55 PM


All times are GMT +1. The time now is 11:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"