Dictionary and saving workbook/ reopening
The object will go out of scope when you close the workbook containing it.
Depending on what you're storing in the dictionary, you may be able to persist the contents by (eg) writing the string key/value
pairs to a file or worksheet. If you're storing objects in the dictionary then you'd have to persist each object in a storable
format (eg. string) and reccreate the objects when the dictionary is recreated ans populated.
--
Tim Williams
Palo Alto, CA
wrote in message oups.com...
If I have a scripting.dictionary object that is declared in a module
and used by a variety of functions in my workbook, and then I save my
workbook and close it, will that dictionary still be around with the
same data in it when I reopen the workbook. If not, how could I make it
so it would?
Thanks in advance,
-Abe
|