MacScript Function

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Executes an AppleScript script and returns a value returned by the script, if any.


MacScript script

The script argument is a String expression. The String expression either can be a series of AppleScript commands or can specify the name of an AppleScript script or a script file.


Multiline scripts can be created by embedding carriage-return characters (Chr(13)).


This example uses the MacScript function to open the Choose File dialog box (the Macintosh standard-file dialog). The full path of the file chosen by the user is returned. If appropriate, the path specification is preceded by the type of the file.

ThePath$ = Macscript("ChooseFile")