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.
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
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.