Home

Can't open VBA excel workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-716974%22%20slang%3D%22en-US%22%3ECan't%20open%20VBA%20excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-716974%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20VBA%20program%20that%20sometimes%20wouldn't%20open.%20When%20I%20try%20to%20open%20it%2C%20it%20says%20%22Microsoft%20Excel%20has%20stopped%20working%22%20and%20below%20is%20the%20detail%20of%20the%20problem.%20Please%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%20signature%3A%3CBR%20%2F%3EProblem%20Event%20Name%3A%20BEX%3CBR%20%2F%3EApplication%20Name%3A%20EXCEL.EXE%3CBR%20%2F%3EApplication%20Version%3A%2016.0.11629.20246%3CBR%20%2F%3EApplication%20Timestamp%3A%205cfadbef%3CBR%20%2F%3EFault%20Module%20Name%3A%20unknown%3CBR%20%2F%3EFault%20Module%20Version%3A%200.0.0.0%3CBR%20%2F%3EFault%20Module%20Timestamp%3A%2000000000%3CBR%20%2F%3EException%20Offset%3A%2000000000%3CBR%20%2F%3EException%20Code%3A%20c0000005%3CBR%20%2F%3EException%20Data%3A%2000000008%3CBR%20%2F%3EOS%20Version%3A%206.1.7601.2.1.0.256.48%3CBR%20%2F%3ELocale%20ID%3A%204105%3C%2FP%3E%3CP%3EAdditional%20information%20about%20the%20problem%3A%3CBR%20%2F%3ELCID%3A%201033%3CBR%20%2F%3Eskulcid%3A%201033%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-716974%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-717196%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20VBA%20excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-717196%22%20slang%3D%22en-US%22%3EDoes%20it%20allow%20you%20to%20open%20it%20if%20you%20first%20disable%20all%20macros%20(in%20Excel%20options%2C%20trust%20center%2C%20trust%20center%20settings)%20befor%20eopening%20the%20file%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-717337%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20VBA%20excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-717337%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BYes%2C%20I%20can%20open%20it%20if%20i%20disable%20macros%20beforehand.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-717401%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20VBA%20excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-717401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365525%22%20target%3D%22_blank%22%3E%40Adogeb%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EYou%20need%20to%20check%20the%20VBA%20code%20and%20find%20out%20the%20causes%20of%20the%20crash.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-717402%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20VBA%20excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-717402%22%20slang%3D%22en-US%22%3EIn%20that%20caase%20you%20can%20try%20opening%20the%20workbook%20with%20macro's%20enabled%20but%20also%20making%20sure%20you%20prevent%20the%20Workbook_Open%20event%20like%20so%3A%20%3CA%20href%3D%22https%3A%2F%2Fjkp-ads.com%2FArticles%2Fpreventopenevent.asp%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fjkp-ads.com%2FArticles%2Fpreventopenevent.asp%3C%2FA%3E%3CBR%20%2F%3EOnce%20open%2C%20open%20the%20VBA%20Editor%2C%20locate%20the%20Workbook_Open%20event%20and%20stert%20stepping%20through%20it%20until%20you%20find%20the%20line%20that%20causes%20the%20crash.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-717420%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20VBA%20excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-717420%22%20slang%3D%22en-US%22%3EOK%2C%20thanks%2C%3C%2FLINGO-BODY%3E
Adogeb
New Contributor

Hi,

 

I have a VBA program that sometimes wouldn't open. When I try to open it, it says "Microsoft Excel has stopped working" and below is the detail of the problem. Please help!

 

Problem signature:
Problem Event Name: BEX
Application Name: EXCEL.EXE
Application Version: 16.0.11629.20246
Application Timestamp: 5cfadbef
Fault Module Name: unknown
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Offset: 00000000
Exception Code: c0000005
Exception Data: 00000008
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 4105

Additional information about the problem:
LCID: 1033
skulcid: 1033

 

 

5 Replies
Does it allow you to open it if you first disable all macros (in Excel options, trust center, trust center settings) befor eopening the file?

@Jan Karel Pieterse Yes, I can open it if i disable macros beforehand.

@Adogeb

 

You need to check the VBA code and find out the causes of the crash.

In that caase you can try opening the workbook with macro's enabled but also making sure you prevent the Workbook_Open event like so: https://jkp-ads.com/Articles/preventopenevent.asp
Once open, open the VBA Editor, locate the Workbook_Open event and stert stepping through it until you find the line that causes the crash.
OK, thanks,