I have an excel with vba in it that runs perfectly but crashes when I try to save it... here is the report data can anyone point me int the right direction as to what is causing it to crash have attached first part mages of the error report as cannot copy all of it in
Error Signature:
Exception: EXC_CRASH (SIGABRT)
ExceptionEnumString: 805306368
Exception Code: 0x00000001 (0x0000000000000000)
Date/Time: 2024-01-22 12:50:51 +0000
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Bitness: x64
Application Version: 16.81.0.24011420
Crashed Module Name: merp
Crashed Module Version: 16.81.24011420
Crashed Module Offset: 0x0000000000009eb3
Blame Module Name: mso20
Blame Module Version: 16.81.24011420
UnsymbolicatedChecksum: 7A38CFF605F68467CB197D4C22D68E38
Blame Module Offset: 0x000000000000685c
StackHash: 50ab3ee34a6ea074_805306368_bk_oom
Application LCID: 2057
Extra app info: Reg=en Loc=0x0809
Build Type: Release
Crashed thread Stack Pointer: 0x_000070000d526a50
Crashed thread: 48
Thread 0 (0xaaf07):
# 1 0x00007ff81743233d in (UnknownModule + 0x0000000000000000) 0x0000000000000000
# 2 0x00007ff81741127a in (UnknownModule + 0x0000000000000000) 0x0000000000000000
# 3 0x00007ff81761dc88 in _backtrace_symbols + 0x0000006B (libsystem_c.dylib + 0x0000000000014c88) 0x00007ff7b0c4fb40
# 4 0x00007ff8187f65ae in -[_NSCallStackArray objectAtIndex:] + 0x00000068 (Foundation + 0x00000000000745ae) 0x00007ff7b0c4fba0
# 5 0x00007ff81780950e in _CFArrayApplyFunction + 0x00000035 (CoreFoundation + 0x000000000003f50e) 0x00007ff7b0c4fbe0
# 6 0x00007ff8178092b7 in ___CFPropertyListIsValidAux + 0x000001CF (CoreFoundation + 0x000000000003f2b7) 0x00007ff7b0c4fc20
# 7 0x00007ff81780ab32 in ___CFPropertyListIsDictPlistAux + 0x000000B4 (CoreFoundation + 0x0000000000040b32) 0x00007ff7b0c4fca0
# 8 0x00007ff817803913 in -[__NSDictionaryM __apply:context:] + 0x00000066 (CoreFoundation + 0x0000000000039913) 0x00007ff7b0c4fcd0
# 9 0x00007ff8178092f9 in ___CFPropertyListIsValidAux + 0x00000211 (CoreFoundation + 0x000000000003f2f9) 0x00007ff7b0c4fd10
10 0x00007ff81783b82e in _CFPropertyListCreateData + 0x000000D0 (CoreFoundation + 0x000000000007182e) 0x00007ff7b0c4fd90
12 0x00007ff8187c1512 in -[NSDictionary(NSDictionary) writeToURL:atomically:] + 0x0000007A (Foundation + 0x000000000003f512) 0x00007ff7b0c4fe20
13 0x0000000113538213 in (merp + 0x0000000000013213) 0x00007ff7b0c4fe70
14 0x00000001135384ba in (merp + 0x00000000000134ba) 0x00007ff7b0c4fed0
15 0x00007ff8173ab321 in _objc_exception_throw + 0x00000030 (libobjc.A.dylib + 0x0000000000014321) 0x00007ff7b0c4ff10
17 0x00007ff81b0e4981 in -[NSApplication _commonBeginModalSessionForWindow:relativeToWindow:modalDelegate:didEndSelector:contextInfo:] + 0x00000054 (AppKit + 0x00000000002d0981) 0x00007ff7b0c50fe0
18 0x00007ff81b0e4924 in -[NSApplication beginModalSessionForWindow:] + 0x00000025 (AppKit + 0x00000000002d0924) 0x00007ff7b0c51040
19 0x00007ff81b0e488a in ___35-[NSApplication runModalForWindow:]_block_invoke_2 + 0x00000027 (AppKit + 0x00000000002d088a) 0x00007ff7b0c51060
20 0x00007ff81b0e4850 in ___35-[NSApplication runModalForWindow:]_block_invoke + 0x00000046 (AppKit + 0x00000000002d0850) 0x00007ff7b0c51090
21 0x00007ff81b0e40f2 in __NSTryRunModal + 0x00000064 (AppKit + 0x00000000002d00f2) 0x00007ff7b0c510e0
22 0x00007ff81b0e3fc4 in -[NSApplication runModalForWindow:] + 0x00000136 (AppKit + 0x00000000002cffc4) 0x00007ff7b0c51100
23 0x00000001137c3498 in (CocoaUI + 0x0000000000074498) 0x00007ff7b0c511e0
24 0x000000011f706143 in (mso99 + 0x00000000012aa143) 0x00007ff7b0c51210
25 0x000000011f4fe2d7 in (mso99 + 0x00000000010a22d7) 0x00007ff7b0c51250
26 0x000000011f4fdb05 in (mso99 + 0x00000000010a1b05) 0x00007ff7b0c51270
27 0x000000011f1921a6 in (mso99 + 0x0000000000d361a6) 0x00007ff7b0c51450
28 0x000000011f19a99b in (mso99 + 0x0000000000d3e99b) 0x00007ff7b0c51460
29 0x000000011e4b8f2e in (mso99 + 0x000000000005cf2e) 0x00007ff7b0c52580
30 0x00000001113ec0a0 in (Microsoft Excel + 0x00000000021580a0) 0x00007ff7b0c57b00
31 0x00000001113eb943 in (Microsoft Excel + 0x0000000002157943) 0x00007ff7b0c57b90
32 0x00000001113eb7b4 in (Microsoft Excel + 0x00000000021577b4) 0x00007ff7b0c57c00
33 0x00000001113eb5d4 in (Microsoft Excel + 0x00000000021575d4) 0x00007ff7b0c57d10
34 0x00000001113eb513 in (Microsoft Excel + 0x0000000002157513) 0x00007ff7b0c57d80
35 0x00000001108a20ae in (Microsoft Excel + 0x000000000160e0ae) 0x00007ff7b0c58e20
36 0x00000001108a3b39 in (Microsoft Excel + 0x000000000160fb39) 0x00007ff7b0c5c4a0
37 0x00000001108a4201 in (Microsoft Excel + 0x0000000001610201) 0x00007ff7b0c5d7b0
38 0x0000000111195e3f in (Microsoft Excel + 0x0000000001f01e3f) 0x00007ff7b0c5d940
39 0x0000000111184866 in (Microsoft Excel + 0x0000000001ef0866) 0x00007ff7b0c67ca0
40 0x00000001111840a0 in (Microsoft Excel + 0x0000000001ef00a0) 0x00007ff7b0c67e40
41 0x0000000111184ba5 in (Microsoft Excel + 0x0000000001ef0ba5) 0x00007ff7b0c697c0
42 0x000000010f328abe in (Microsoft Excel + 0x0000000000094abe) 0x00007ff7b0c698c0
43 0x000000010f31c526 in (Microsoft Excel + 0x0000000000088526) 0x00007ff7b0c69e40
44 0x00000001104fc939 in (Microsoft Excel + 0x0000000001268939) 0x00007ff7b0c6a190
45 0x000000010f3f3008 in (Microsoft Excel + 0x000000000015f008) 0x00007ff7b0c6a1b0
47 0x00007ff81786142c in ___CFRUNLOOP_IS_CALLING_OUT_TO_A_TIMER_CALLBACK_FUNCTION__ + 0x00000014 (CoreFoundation + 0x000000000009742c) 0x00007ff7b0c6a260
48 0x00007ff817860fda in ___CFRunLoopDoTimer + 0x00000311 (CoreFoundation + 0x0000000000096fda) 0x00007ff7b0c6a270
49 0x00007ff817860c16 in ___CFRunLoopDoTimers + 0x0000011D (CoreFoundation + 0x0000000000096c16) 0x00007ff7b0c6a320
50 0x00007ff817844f02 in ___CFRunLoopRun + 0x00000838 (CoreFoundation + 0x000000000007af02) 0x00007ff7b0c6a370
51 0x00007ff817844102 in _CFRunLoopRunSpecific + 0x0000022D (CoreFoundation + 0x000000000007a102) 0x00007ff7b0c6b0c0
55 0x00007ff81ae527b9 in __DPSNextEvent + 0x00000370 (AppKit + 0x000000000003e7b9) 0x00007ff7b0c6b260
56 0x00007ff81b74af64 in -[NSApplication(NSEventRouting) _nextEventMatchingEventMask:untilDate:inMode:dequeue:] + 0x00000518 (AppKit + 0x0000000000936f64) 0x00007ff7b0c6b640
57 0x00007ff81ae43d32 in -[NSApplication run] + 0x0000025B (AppKit + 0x000000000002fd32) 0x00007ff7b0c6b840
58 0x00007ff81ae17d41 in _NSApplicationMain + 0x00000330 (AppKit + 0x0000000000003d41) 0x00007ff7b0c6b8c0
59 0x00007ff8173df386 in (UnknownModule + 0x0000000000000000) 0x00007ff7b0c6b910
x86_64 Thread State(64bit):
__rax: 0x00007ff8999fd1a0 __rbx: 0x00007ff89732f000 __rcx: 0x00007ff7b0c4f998 __rdx:0x00007ff8999fc890
__rdi: 0x00007ff7b0c4f998 __rsi: 0x00007ff899a0afa0 __rbp: 0x00007ff7b0c4fa00 __rsp:0x00007ff7b0c4f8f0
__r8: 0x00007ff841e04d83 __r9: 0x0000000000000b80 __r10: 0x0000000000000001 __r11:0x00007ff880000000
__r12: 0x00007ff81ae14000 __r13: 0x00007ff899815bb0 __r14: 0x00007ff7b0c4fad0 __r15:0x00007ff803db5981
__rip: 0x00007ff81743233d __rflags: 0x0000000000010206 __cs: 0x000000000000002b __fs:0x0000000000000000
__gs: 0x0000000000000000
Thread 1 (0xaaf18):