Arrays

[mikeymay]

I built a project in 2019 which uses a specific line of code to create an object to allow the use of arrays

Set ObjForSList = CreateObject("system.collections.arraylist")

This project no longer works and debugs on the above code.

Looking at some references around VBA defined arrays, it seems that if the .Net Framework version is not v3.5 then it won't work. This includes later than v3.5 as well!

Is there a way of working with arrays in a way that isn't restricted by the .NET Framework version?


TIA

 

[RoryA]

Arrays and the arraylist are not the same thing. What are you using the arraylist for - sorting?

 

[mikeymay]

Arrays and the arraylist are not the same thing. What are you using the arraylist for - sorting?

Yes, the original code sorted the array once established.

I am thinking just to dump the array values into a holding sheet via a for loop and then sortring rather than making it too complicated.....

 

[RoryA]

There are lots of VB/VBA methods for sorting arrays in memory (eg bubble sort / quick sort) and numerous examples of code around...

 

[mikeymay]

Thanks for the tip.

I'll have a dig around and get somethign working!