I'm running 32 bit Excel 2013 Home and Student version with 64 bit Windows 8.1 installed on a VMWare virtual machine. When I try to run any macro involving Systems.Collection... I get an automation error on the CreateObject Line. For example, the following simple routine (from Jindon, I believe) fails.
Code
Sub arraylist()
Dim arr()
With CreateObject("System.Collections.arraylist")
.Add "Kyle"
.Add "123"
Sheet1.Cells(1, 1).Resize(, 2).Value = .toarray()
End With
End Sub
Display More
I know I can't use PowerPivot with my Excel version. Does anyone know if that also is a limitation in this case?
Thanks for any advice or explanation. Google has so far been of no help.