PDA

View Full Version : Ragged Arrays



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

shasur
10-04-2007, 11:55 PM
You are correct
VBA does not support ArrayList