stanl
08-16-2007, 01:20 AM
This works in vbScript
Set oList = CreateObject("System.Collections.ArrayList")
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? :banghead: Stan
Set oList = CreateObject("System.Collections.ArrayList")
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? :banghead: Stan