"Random" Excel VBA Errors

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: "Random" Excel VBA Errors

  1. #1
    Board Regular
    Join Date
    Aug 2006
    Posts
    160
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default "Random" Excel VBA Errors

     
    I have an Excel VBA workbook that has been distributed to many users. Some users are working with it without any difficulty. Other users ( a very small percentage) are receiving "Code Execution has been interrupted" errors. Using the debug feature the errors appear to be random with the program stopping on End Sub and End Function lines of code as well as other code lines. Single stepping through the code using F8 does not generate errors. The users having problems have the same Excel version and service pack as the users not having problems. Any tips on what could be causing the errors or where I should look?

  2. #2
    New Member
    Join Date
    Jan 2006
    Location
    Orlando, FL
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "Random" Excel VBA Errors

    A few of my co-workers had the same exact thing happen to them. It's happened to about 5 of my users within the past year ... the first time, the box was popping up every few minutes, the later users every so often.

    The "Code Excecution has been interrupted" window would pop up, but since there was no error, they could press the "Continue" button, and continue on... until the next time it popped up. It was if somehow CTRL+BREAK was being pressed by a gremlin inside the computer.

    I could not find any rhyme or reason to why this was popping up.

    Not sure why, but after several reboots, the problem went away. Whether there was a correlation to the reboots, I do not know.

  3. #3
    Board Regular
    Join Date
    Apr 2009
    Posts
    441
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "Random" Excel VBA Errors

    Do your users use Acrobat?

  4. #4
    New Member
    Join Date
    Jan 2006
    Location
    Orlando, FL
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "Random" Excel VBA Errors

    Mine will have some form of Adobe Reader installed, as well as a PDF print driver. But I don't think they have the full Acrobat product.

  5. #5
    Board Regular
    Join Date
    Apr 2009
    Posts
    441
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "Random" Excel VBA Errors

    Then it's the Acrobat plugin in Excel that conflicts. It's a known problem.

  6. #6
    Board Regular
    Join Date
    Aug 2006
    Posts
    160
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "Random" Excel VBA Errors

    Silkfire - any known fixes or workarounds?

  7. #7
    New Member
    Join Date
    Nov 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "Random" Excel VBA Errors

      
    I have had this exact problem on Excel 2010. So this thread has saved my sanity. File -> options -> manage add ins dropdown -> COM add ins -> Adobe Pro -> uncheck -> problem solved.
    Thank you so much Silkfire - I would simply never have thought it could be Adobe related.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com