+ Reply to Thread
Results 1 to 4 of 4

Excel automation errors with arrays in office 365

  1. #1
    Forum Contributor
    Join Date
    01-08-2017
    Location
    Salt Lake City, Ut.
    MS-Off Ver
    2010
    Posts
    117

    Question Excel automation errors with arrays in office 365

    I am still working with dropdown comboboxes that are in the attached file. These work great in Excel Office 2019 where I create my excel vba files, but when I move these to either office 365 excel 32 bit or 64 bit, (one laptop wit excel 32 bit and another with excel 64 bit), it fails with Automation errors trying to utilize the dropdown list functions. I also get additional errors. Please see all attached files.

    I have looked for any libraries that perhaps need added to excel office 365 to support the arrays / lists that are used in the combobox focus routine, but have been so far unsuccessful in finding any add-in for office 365. Does anyone know if there is a solution for these problems in office 365 or is this just not supported?
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    945

    Re: Excel automation errors with arrays in office 365

    I'm using Office 365, and I have no issue with "System.Collections.ArrayList". And I didn't add any library or reference to make it work.
    But if you want I can replace "System.Collections.ArrayList" with "scripting.dictionary" in your code.
    But let's see if "scripting.dictionary" works on your system.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-08-2017
    Location
    Salt Lake City, Ut.
    MS-Off Ver
    2010
    Posts
    117

    Re: Excel automation errors with arrays in office 365

    I tried the "scripting.distionary" in both the office 365, 32 and 64 bit versions. It does work. I have also attached some additional snapshots showing version info and various add-ins. One thing that I did not mention earlier, is that this off 365 is the home version on these laptops, so I am not sure if that might make a difference or not.

    Thank you for your help.
    Attached Images Attached Images

  4. #4
    Forum Contributor
    Join Date
    01-08-2017
    Location
    Salt Lake City, Ut.
    MS-Off Ver
    2010
    Posts
    117

    Red face Re: Excel automation errors with arrays in office 365

    Problem Resolved: I knew that something had to be missing in Office 365 and I finally found it. Windows10 on both systems were missing the .NET Framework 3.5 (includes .NET 2.0 and 3.0). I turned this feature on, on both of my laptops, and now the combobox feature works great in both the office 365 32bit and 64 bit versions.

    To turn this on, one must type "Features" in the windows search bar, then after selecting Apps and Features, type Windows Features in the next search bar. Next click on Turn Windows features on or off. In the popup windows,select the .NET Framework 3.5 (includes .NET 2.0 and 3.0) feature at the top and click OK. Then choose to let windows search and download the feature. Be aware that this may take awhile, but once downloaded, it will install. Then this issue was resolved.
    Attached Images Attached Images
    Last edited by dentler; 06-23-2021 at 07:22 PM.

+ 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. VBA excel macro generates "automation error" randomly using Office 365
    By kolback in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2014, 06:28 AM
  2. Excel Automation Errors
    By miztaken in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2008, 07:05 AM
  3. [SOLVED] Office SP2 update causes Excel automation crash!
    By Rob Schripsema in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2006, 08:20 PM
  4. [SOLVED] Office SP2 update causes Excel automation crash!
    By Rob Schripsema in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2006, 06:16 PM
  5. Automation Errors
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2005, 02:06 PM
  6. Automation Errors
    By Mike Larson in forum Excel General
    Replies: 2
    Last Post: 02-03-2005, 05:06 PM

Tags for this Thread

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