macOS

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.

PLEASE HELP!!!!!!!!