Results 1 to 10 of 10

Automation Error - Thrown Out of Excel

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Karlstad, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    232

    Automation Error - Thrown Out of Excel

    Hi,

    I'm thrown out of Excel without warnings. It occurs when I open a form inside another form:
    - If the 1st form is open in background --> I'm thrown out of Excel when I close the 2nd form. No warnings.
    - If the 1st form is closed (Unload Me) before I open the 2nd form --> Everything is OK (I show the 1st form again when I close the 2nd form)

    I have opened forms inside other forms in multiple applications before. No issues at all. It's only in this specific application. That's why I'm confused.

    I've tested to add DoEvents, Application.Wait, ... in the code in specific locations but nothing seems to help. Sometimes I get following message before being thrown out of Excel. I've added a picture file.

    Has anyone experienced this issue?
    Attached Images Attached Images
    1. Reply to thread and inform if suggestion was helpful or not
    2. Click on the star (=Add Reputation) if you think someone helped you
    3. Mark [SOLVED] to this thread if solution was found. (On Menu "Thread Tools" > "Mark this thread as solved")

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vba excel - error thrown in module after userform unloads
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-15-2021, 06:39 AM
  2. [SOLVED] End macros in all related subs when error thrown
    By guyglk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2021, 04:17 PM
  3. Error thrown by VLookup when not an error
    By mms in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2019, 10:25 AM
  4. [SOLVED] Macro to remove text is not exacuting, but no error being thrown either
    By capson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2015, 02:55 PM
  5. Thrown out of Excel...
    By Joakim N in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2014, 02:45 AM
  6. Facing 'run-time error -2147217871 (80040e31) Automation error' in excel VBA
    By junaidanjum in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2013, 03:48 AM
  7. Replies: 7
    Last Post: 01-15-2010, 02:34 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