View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_3_] Robert Crandal[_3_] is offline
external usenet poster
 
Posts: 161
Default Efficient storage

"Claus Busch" wrote:

Set myDic = CreateObject("Scripting.Dictionary")


BTW, I never knew about this "Scripting Dictionary".
Is this an object that can store an entire library of words?

If so, do you think I would be better off storing all of my
unique words in the dictionary object, rather than saving them
in columns on the spreadsheet?

If I am able to store all my unique words in a memory object,
I could then iterate through the object and output all the words
to a text file. That might even be better for me.