I am looking for a book to buy so that i can learn the use of System.Collections.ArrayList, System.Collections.SortedList and Scripting Dictionary used in Excel VBA.
do you know any good book that explains these by example?
I am looking for a book to buy so that i can learn the use of System.Collections.ArrayList, System.Collections.SortedList and Scripting Dictionary used in Excel VBA.
do you know any good book that explains these by example?
I am pretty sure those are from the .net framework. They arent specifically part of VBA itself nor any other language. They are part of a library/api. See here
The example I know your question stems from used late binding as to not need to set the reference for it to work. The downside is you loose the intellitype predictive and help text as you write the code.
A built in alternative would be to use a VBA collection. You could use a dictionary object as well but that also comes from a reference. There are trade offs to using these various data constructs. Typically VBA arrays are the fastest but can be a pain to deal with.
Not fully compatible in vba
ArrayList
https://msdn.microsoft.com/en-us/lib...v=vs.110).aspx
SortedList
https://msdn.microsoft.com/en-us/lib...v=vs.110).aspx
If you google those keywords with my handle, you will find a few examples.
thank you both
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks