
The MacScript command has to specify both the full location of Prism and the script that Prism will launch. “open file “”Macintosh HD:Prism4:Scripts:dr2””” + Chr(13) + _ MacScript “tell application “”HD:Prism4:Prism””” + Chr(13) + _ Launch Prism with this MacScript command. These examples assume you are running Visual Basic for Applications (VBA) from within Excel.
/article-new/2018/05/automator-set-value-of-variable.jpg)
MacScript commands let you launch Prism from Word or Excel. Run a script from Microsoft Office using MacScript

The output is either the word “Done” or an error message. The inputs to this Action is either a file containing a Prism script, or the text of the script itself. If you use OSX 10.4 (“Tiger”) or later, Prism installs an Automator Action that lets you launch a Prism script.
