This works in vbScript
[vba]
Set oList = CreateObject("System.Collections.ArrayList")
[/vba]
but in VBA [in an Excel sub] I get Automation Error. It appears it is not possible for VBA to accept a .NET collection - correct?Stan
This works in vbScript
[vba]
Set oList = CreateObject("System.Collections.ArrayList")
[/vba]
but in VBA [in an Excel sub] I get Automation Error. It appears it is not possible for VBA to accept a .NET collection - correct?
You are correct
VBA does not support ArrayList
Posting Permissions
Reply With Quote