I am trying to run a Shell script from Excel using VBA. The prompt which runs correctly in Terminal is. The following code attempts to run that line, but raises![]()
cat 'prompt.csv' | sh runScript.sh 'WSO'
The notebook this script is attached to, prompt.csv, and runScript.sh files all live in the same folder. I am using Office 2016 for Mac. Any help is much appreciated.![]()
Error 53: File Not Found
![]()
Sub Run_Jar() ChDir ActiveWorkbook.Path Shell "cat 'prompt.csv' | sh runScript.sh 'WSO'" End Sub
Bookmarks