I have tried using both the Shell function and the MacScript function, but the VBA interpreter doesnt seem to be able to find the script in either case.

This is likely to be the simplest option and what I would suggest doing.

The downside is that it has quite a lot of overhead (100-200ms per call).

If you want to get the output from the command, you could use popen().

Private Declare Function pclose Lib libc.dylib (ByVal file As Long) As Long.

Private Declare Function fread Lib libc.dylib (ByVal outStr As String, ByVal size As Long, ByVal items As Long, ByVal stream As Long) As Long.

Function execShell(command As String, Optional ByRef exitCode As Long) As String.

To get my script to work, I had to resolve some path and permissions issues (not the script itself, but things touched by the script).

For Excel 15.18 (2015) the open call used in the system() function from the standard C library doesnt need the --args keyword anymore.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged excel vba macos shell or ask your own question.

Running Function On Excel For Mac