Simple Visual Basic application crashes Excel with VBA7.1\vbe7.dll faulting module

Vicnesh Nathan 1 Reputation point
2021-11-02T17:06:38.223+00:00

When using a VISA-COM library 5.13 of from Keysight IO Libraries Suite in a VBA program, Excel crashes and closes.

The crash seems to occur with only a certain version of Excel released recently.

September 14: Version 2108 (Build 14326.20404) crash does not occur

September 28: Version 2109 (Build 14430.20234) crash occurs

In 1 out of 4 cases, the event improved with the version upgrade of Excel on October 12th.

October 12: Version 2109 (Build 14430.20298)

Checked the VISA-COM library and there are no errors in that library.

The VBA version should be 7.1.

Windows Event Viewer - Application.evtx shows an Excel application error:

Faulting application name: EXCEL.EXE, version: 16.0.14527.20226, time stamp: 0x617358db

Faulting module name: VBE7.DLL, version: 0.0.0.0, time stamp: 0x612d1ff0

Exception code: 0xc0000005

Fault offset: 0x000xxx

Faulting process id: 0x5e0

Faulting application start time: 0x01d7cebcxxxx

Faulting application path: C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE

Faulting module path: C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL

Report Id: 5bece173-xxxx-4675-b0d3-3eexxxxxxxx

Faulting package full name:

Faulting package-relative application ID:

Event Name: APPCRASH

Response: 使用不可

Cab Id: 0

Problem signature:

P1: EXCEL.EXE

P2: 16.0.14527.20226

P3: 617358db

P4: VBE7.DLL

P5: 0.0.0.0

P6: 612d1ff0

P7: c0000005

P8: 000caa4a

P9:

P10:

Attached files:

\?\D:\Users\Morio\Documents\tmp\20211101-VisaComExcel\FMIO-01.xlsm

\?\C:\Users\Morio\AppData\Local\Temp{5F0FB6B6-1BA5-437E-A82F-3FC60771800E} - OProcSessId.dat

\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERxxx.tmp.WERInternalMetadata.xml

\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERxxx8.tmp.xml

\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERxxx8.tmp.csv

\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERxxx7.tmp.txt

These files may be available here:

\?\C:\ProgramData\Microsoft\Windows\WER\ReportArchive\AppCrash_EXCEL.EXE_66b6ff9f3bexxxxxxxxxxxx_00000000_39xxxxx81-4f0f-bb09-fxxxxxx

Analysis symbol:

Rechecking for solution: 0

Report Id: 5bece173-d178-4675-b0d3-xxxxxxxxx

Report Status: 268435456

Hashed bucket: a316a20440dfe77axxxxxxxx

Cab Guid: 0

  1. These crashes seem to be occurring in Excel with possibly Japanese regional language settings. Have others seen these vbe7.dll related crashes?
  2. Any ideas on how to troubleshoot further?
  3. I find it difficult to get these exact Excel version installers, do you have any suggestions on how to get these so that I can replicate the crash on the same version of Excel?
  4. I found a thread suggesting to turn off the Compile on Demand and I'm trying to track down the bit-ness of these Excel's to see if they are all 32-bit or 64-bit?
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,517 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vicnesh Nathan 1 Reputation point
    2021-11-03T19:47:32.15+00:00

    Update: Turning off Compile on Demand does not seem to help with this crash. Also, this problem seems to be affecting both 32-bit and 64-bit Excel.

    0 comments
  2. Vicnesh Nathan 1 Reputation point
    2021-11-23T20:27:48.83+00:00

    Able to replicate the issue on my work computer now after our IT updated our MS Office on 11/17/2021. But going through the VBA program and stepping through the VISA-COM Library initialization, methods and close, it works as expected.

    The problem is when VBA exits a subroutine and has to garbage collect any unused objects and return back to the Excel spreadsheet.

    Here is a video of my observation: https://drive.google.com/file/d/1sCGzJfUkPqP2mRLrpPeIQQPCdPZeDfC_/view?usp=sharing

    0 comments
  3. Vicnesh Nathan 1 Reputation point
    2021-11-24T18:08:08.65+00:00
    1. Managed to resolve the issue by uninstalling MS Office 365 the second time around from Programs and Features.
    2. Going to my companies IT provided MS Office 365 portal (URL was something portal.office.com and logged in with my work email).
    3. Clicking on the Install Office button and downloading a OfficeSetup.exe
    4. Running the .exe to reinstall MS Office 365 applications with Administrator privileges
    5. Reboot
    6. Launch my Excel program with the VBA code referencing VISA-COM Library 5.12 and ran it without the crash anymore.

    So the bug looks to be happening when the MS Office 365 was updated and it basically breaks the Exit Sub process when objects in the VBA program are supposed to be Garbage Collected.

    0 comments
  4. Vladimir Pucek 1 Reputation point
    2021-11-30T09:53:36.9+00:00

    Hello MS team,

    I have still the same problem with MS Excel and GPIB communication via VISA-COM Library after the reinstalling MS Office 365 64-bit from portal.office.com.
    Could you support us?

    thanks
    Vladimir Pucek

    0 comments
  5. Enrico Coscelli 1 Reputation point
    2021-11-30T10:31:20.167+00:00

    Dear MS Team,

    I'm experiencing the same issue starting from version 2109 (build 14430.20342, 32 bit). Un-installing and re-installing up-to-date version 2111 didn't solve the problem.
    Can you support?

    Thanks.

    0 comments