CreateObject("System.Collections.arraylist") Automation Error

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


    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.

  • Re: CreateObject("System.Collections.arraylist") Automation Error


    That class is installed by default for most Windows machines as part of the standard vb.net framework files.


    I guess you could try downloading those framework files. Install through the virtual scheme somehow and see if that resolves the issue.


    This is old but maybe something newer along those lines would help. https://www.youtube.com/watch?v=ZUSCqyKCLls
    or the usual v4.0 files: https://www.microsoft.com/en-U…oad/details.aspx?id=17718

  • Re: CreateObject("System.Collections.arraylist") Automation Error


    It depends on Windows version since System.Collection is a .Net Framework object.


    It should be installed automatically if your windows is 2003 or later.


    Check if you have


    c:\Windows\Microsoft.Net\Framework


    Otherwise, you can install from MS.

  • Re: CreateObject("System.Collections.arraylist") Automation Error


    Hi Derk,


    If I set the reference to


    C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorlib.tlb


    It altumatically set the refence to mscorlib.dll and I can use early bind like

    Code
    Dim AL As ArrayList
         Set AL = New ArrayList


    Does this help?

  • Re: CreateObject("System.Collections.arraylist") Automation Error


    Ahh, the light finally came on thanks to your hints, The Net Framework I have is 64 bit, but Excel is 32 bit, I suppose I could also install an older Framework Or I could just live without the few things MSCORLIB has to offer.

  • Re: CreateObject("System.Collections.arraylist") Automation Error


    Derk,


    I also use Windows as a virtual machine (in my case using Virtual Box inside Linux Ubuntu), I have many VMs created with different combinations of OS and Excel version so that I can duplicate systems of anyone asking questions or client's systems. I run PowerPivot on just about every one and system.collections.... work on every system. I think it would be worth your while downloading the correct .Net Framework, and if you install the minimal Visual Studio you would probably find that PowerPivot could be installed too.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!