Question:
At an application, a script is used to return all objects that are in a data folder. For example:
 For each obj in Application.GetObject(“Data”)
 MsgBox obj.name
 Next
Why are the items not returned in alphabetical order when executing this script?
Question:
This happens because when you use a for each loop, the system does not return data sorted alphabetically, but in the order that the objects were created.
To fix this problem, you must use the following script:
 Set data = Application.GetObject(“Data”)
 Set DataList = CreateObject(“System.Collections.ArrayList”)
Â
 For each obj in data
 DataList.Add obj.name
 Next
Â
 DataList.Sort()
Â
 For Each obj1 in DataList
    MsgBox obj1
 Next
IMPORTANT: In order to execute this script, you must install Microsoft .NET Framework 3.5
Attachments:
