Faulting module name: VBE7.DLL Crashing Excel

Hello Sola !!!

I have done more checking and....

1.- I don't have missing References

2.- I don't have Syntax errors

3.- I have discovered 2 more statements that were protected with "On Error Resume Next" and change the code to avoid causing "protected" errors. The "On Error Resume Next" was removed from those 2 statements.

So far, executing my VBA code in Safe mode has allowed me to stay away from Excel crashing.

Regarding the references I have, I am a little bit confused about how to check the versions of each of them.

The references I have are the following:

In the case of the first reference:

a) The above window does not show the complete path of the location of the reference.

b) I searched for "VBA7" on my Program Files folder and found that I hace 2 VBA7.1 folders; one for x86 (32bit) and another for x64 (64bit).

c) My Microsoft 365 is

64Bit as you can see about and I don't know how to check which VBA7 is being used. I am assuming it is the 64Bit one since Microsoft 365 is 64Bit.

There are other references like Ole Automation,

That, as you can see, the Location points to file stdole2.tlb that I found and there is no version informatio about it as you can see below....

In summary I don't know how to precisely check the versions of my References.

Could you please point me to or let me know how to do it ?

My Microsoft 365 is updated to the latest version.

I will continue testing my code trying to get rid of all or most "On Error Resume Next" protections and will return here to share more findings.

Waiting for your kind response,

Ed

Hi again,

I'm sorry I wasn't able to help, unfortunately, I do not have any more troubleshooting to offer, there are knowledgeable experts on the platform and I hope someone else will take a look at your issue.

Thanks, Sola

Hello Sola !!!

Thank you very much for your first response and intention. You helped me and I thank you for that.

I hope someone knowledgeable whishes to take a look at this.

I really have a tight delivery schedule and need to find a way to continue developing VBA code safely and confidently.

Cheers

Ed

Hello !!!

To start the week fresh !!!! ANOTHER Excel CRASH

Faulting application name: EXCEL.EXE, version: 16.0.17126.20126, time stamp: 0x659617f7

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

Exception code: 0xc0000005

Fault offset: 0x0000000000253551

Faulting process id: 0x1c7c

Faulting application start time: 0x01da4269e8d7bf7f

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

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

Report Id: 03d35f77-8a0c-45ed-b25a-f5ad2e3f9307

Faulting package full name: 

Faulting package-relative application ID: 

Cheers

Ed