+ Reply to Thread
Results 1 to 2 of 2

Problems with excel 2016 and System.Collections.SortedList

  1. #1
    Forum Contributor colddeck84's Avatar
    Join Date
    06-18-2016
    Location
    bergen, norway
    MS-Off Ver
    2016
    Posts
    254

    Problems with excel 2016 and System.Collections.SortedList

    Hi guys its been awhile since I last visited here as I have been able to handle most scripting by myself . However yesterday I updated my excel version to 2016 and one of my old codes does not work anymore. This code was created by the great Jindon, maybe you are still around :=)

    Anyway here is the code:

    Please Login or Register  to view this content.
    I get an error on line 42:
    With CreateObject("System.Collections.SortedList")

    As this is some sick ninja code I have no chance at all to fix this . But this code was working perfectly on my previous system so a fix should be rather simple. I´m thinking that I might miss a reference but the error msg I get is not to helpful: "Run-time error "-214623576 (80131700)" Automation error "

    Anyhelp to fix this would be much appreciated .

    Frederik

  2. #2
    Forum Contributor colddeck84's Avatar
    Join Date
    06-18-2016
    Location
    bergen, norway
    MS-Off Ver
    2016
    Posts
    254

    Re: Problems with excel 2016 and System.Collections.SortedList

    I found the problem: I was missing the Microsoft .net framework 3.5 . installed now and everything is working perfectly

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 04-25-2018, 12:13 PM
  2. [SOLVED] is there any book to teach System.Collections.ArrayList, System.Collections.SortedList,
    By Flora20 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2017, 06:35 AM
  3. Help! Automated Email coding for Excel 2016 and Outlook 2016 problems
    By lisa6421 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2017, 08:07 AM
  4. troubles with running a plug-in in excel 2016 on a 64 bit system (mac)
    By samsonicx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2016, 03:28 AM
  5. Problems / small issues in Excel 2016
    By MathiasV in forum Excel General
    Replies: 3
    Last Post: 09-02-2016, 08:03 AM
  6. Excel 2016 Trust Center problems
    By starcrwzr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2016, 06:22 PM
  7. [SOLVED] How to use CreateObject("System.Collections.SortedList") in VBA
    By vnzerem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-20-2013, 10:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1