The MacScript function is not working well in Office for Mac 2016! Any ideas?

by

The MacScript command, used to support inline Apple Scripts in Office for Mac 2011, is being deprecated. Due to restrictions of the sandbox, the MacScript command can no longer invoke other applications such as the Finder. Therefore we discourage the use of this command.

For cases which require changing your existing code so it doesn’t use MacScript, you can use the AppleScriptTask command (see below).

The new AppleScriptTask command executes an AppleScript script. This similar to the MacScript command except that it runs an AppleScript file located outside the sandboxed app.
Call AppleScriptTask as follows:

 Dim myScriptResult as String

 myScriptResult = AppleScriptTask ("MyAppleScriptFile.applescript", "myapplescripthandler", "my parameter string")

Where:

  • The “MyAppleScript.applescript” file must be in ~/Library/Application Scripts/[bundle id]/, the extension applescript is not mandatory, .scpt may also be used
  • “myapplescripthandler” is the name of a script handler in the MyAppleScript.applescript file
  • “my parameter string” is the single input parameter to the “myapplescripthandler” script handler.
  • The corresponding AppleScript for Excel would be in a file named “MyAppleScriptFile.applescript” that is in ~/Library/Application Scripts/com.microsoft.Excel/

Note: The [bundle id]s for Mac Word, Excel and PowerPoint are:

  • com.microsoft.Word
  • com.microsoft.Excel
  • com.microsoft.Powerpoint

An example of a handler is as follows:

on myapplescripthandler(paramString) 

    #do something with paramString 
    return "You told me " & paramString 

end myapplescripthandler

More Related Contents:

  1. Dir() function not working in Mac Excel 2011 VBA
  2. VBA Shell function in Office 2011 for Mac
  3. VBA (Excel) Dictionary on Mac?
  4. Create a folder and sub folder in Excel VBA
  5. Excel 2013 VBA Clear All Filters macro
  6. Checking if a worksheet-based checkbox is checked
  7. How do I issue an HTTP GET from Excel VBA for Mac
  8. How can I install/use “Scripting.FileSystemObject” in Excel 2010 for MAC?
  9. How do you change the value of a cell in excel by clicking on it using VBA? [closed]
  10. Excel Number Separation [closed]
  11. excel vba compare & copy worksheets from 2 excel files
  12. VBA Stuck after certain loop
  13. How do I use FileSystemObject in VBA?
  14. Is the . in .Range necessary when defined by .Cells?
  15. How to return a result from a VBA function
  16. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  17. Properly Handling Errors in VBA (Excel)
  18. Password hash function for Excel VBA
  19. Is there a way to slow down a Web Scraper so it will pick up the code?
  20. Aggregate, Collate and Transpose rows into columns
  21. VBA Excel sort range by specific column
  22. Select method of Range class failed via VBA
  23. Delete cells in an Excel column when rows = 0
  24. Is there a way to import data from .csv to active excel sheet?
  25. Comparison of Dictionary, Collections and Arrays
  26. How to add events to dynamically created controls (buttons, listboxes) in Excel VBA userform
  27. Generate Word Documents (in Excel VBA) from a series of Document Templates
  28. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment