Contents Collection —
Contents collection of the
Application object contains all the application-level scoped
variables and objects added to the current application through the
use of scripts (not through the use of the
Before examining how elements are added to the Contents collection, you must first understand the properties of the Contents collection. The Contents collection has three properties:
Retrieves the value of a specific member of the Contents collection. You specify which member using a string key (whose value is obtainable using the index through the Key property, explained later in this section) or using an index number. For example, if you wish to initialize an element in the Contents collection with the value of Pi, you might use a line of code similar to the following:
Application.Contents.Item("Pi") = 3.14
In the preceding line of code, the desired element in the collection is specified using the key value "Pi." Thus initialized, you can then retrieve the value of this element of the Contents collection using the following line of code:
dblMyVar = Application.Contents.Item("Pi")
For reasons that will become clear in a moment, let's assume that this is the first element added to the Contents collection.
You could also retrieve the value of an element in the Contents collection using its index in the collection rather than a key, as demonstrated in the following line of code:
dblMyVar = Application.Contents.Item(1) ...