I’ve Workplace 365 on a PC operating Home windows 11 and on a Mac Mini operating Sonoma. Each Workplace variations are up-to-date. I develop an Excel VBA software on Widows. After testing completely, I copy the .xlsm file by way of OneDrive over to Mac for testing there. I’ve been doing this for a number of years with the identical software, and have gone by means of many rounds of testing on each Home windows and Mac. However one thing appears to have modified lately.
Immediately, I ran the applying on Mac within the normal manner by double clicking the .xlsm file that I simply introduced over from the PC. The applying halted with an Overflow error. Within the Debugger, this task assertion was flagged:
Dim i as Integer
i = 77
This clearly mustn’t overflow. I used to be in a position to execute the road with out elevating an error by single stepping within the debugger. However once I let this system proceed to run, it halted with an overflow at another trivial task. Identical story: single stepping within the debugger doesn’t increase the error.
I made a decision to attempt launching Excel differently. In Finder, I went to Purposes, and double clicked Excel.app. Within the Open window, I selected my .xlsm file. Now the applying ran faultlessly. To verify it wasn’t a fluke, I ran the take a look at a number of occasions this fashion and it labored each time.
My query is that this: On a Mac, what is the distinction between (1) double-clicking an .xlsm file and (2) operating Excel.app after which deciding on the .xlsm file within the Open window?
john@Johns-Mac-mini ~ % ls -dleO@ /Customers/john/Desktop/BTNS System Testing - Mac/March 2, 2024/Course of Profiler-129.xlsm
-rw-rw----@ 1 john employees - 308577 Mar 2 15:47 /Customers/john/Desktop/BTNS System Testing - Mac/March 2, 2024/Course of Profiler-129.xlsm
com.apple.FinderInfo 32
com.apple.lastuseddate#PS 16
com.apple.macl 72
com.apple.quarantine 30
