I am trying to shell out of VBA in excel and I keep getting permissions issues. So far I have tried:
Full Disk Access
Accessibility
Developer Rights
chmod
Quarantine
Shell function
AppleScriptTask function (with full disks access and Accessiblity, and Developer Rights)
All of the pieces work independently. I can call it from the command line and as an apple script from osascript
The MOST frustrating thing its that once I got the permissions correct on Apple Script, then the excel AppleScriptTask function stopped working. The command that used to work now throws an Error 13 Type Mismatch. I have double checked, triple checked and had Chat GPT write the code. There is not type mismatch - and it worked fine before I fixed the permissions on Apple Script.