Install AppleScriptTask script file or/and Add-in with AppleScript file


When you follow the link below I show you examples on that page about the new VBA command named AppleScriptTask How to use AppleScriptTask in Mac Office, sometimes it is the only way to get things working on a Mac, all my Mail code examples use for example a AppleScriptTask file.

Seems that some people have problems to copy an AppleScriptTask file in the correct location, so this week I create AppleScript for it to install the file in the correct location to make this easier for them I hope. There is also an example to install an Add-in and one that Install an Add-in and AppleScriptTask file. I not say it is perfect but maybe it give you some ideas.

In the test example below I use a AppleScriptTask file with the script below that you can call in your VBA macros to open the folder you want on your Mac : This is the AppleScriptTask script in the OpenFolder.scpt file

Install AppleScriptTask file with AppleScript file on your Mac

What do you need to do? before you can let people install your AppleScriptTask file in the correct location :

  • Create a new folder
  • Copy your AppleScriptTask File in this folder
  • Copy the install file with the install script below also in this folder
  • Be sure that the name of the folder is correct in the Install script
  • Be sure that the name of the AppleScriptTask file is correct in the Install script
  • Be sure that the name of the Install file is correct in the Install script

You can download an example here that install the file named OpenFolder.scpt in the correct folder for you when you run the Install file inside the folder named 'MyAppleScriptTaskFileFolder''. The folder must be in the Users Download folder, you see that if you download the compressed folder from my website it will automatically uncompressed in your Downloads folder and you can double-click the Install.scpt file in it to open and Run it.

Download example (23-8-2024)

You can test the VBA macro below now to see if it will open the AppleScriptTask folder in Finder


And below you see the Script that is in the Install.scpt file.
Note: See the 3 lines in the script that you must change to your own situation if you want to use it.


Tip: You can also save the Install.scpt as Application file (.app), this way the user not see the script.

Install Add-in with AppleScript file on your Mac

The example script below will install an Add-in in Excel in the correct folder on your Mac, it will work almost the same as the first example. Instead of 3 things that you must change there is now a new option to keep the folder with for example help and example files for the add-in in your add-ins folder if you want, read the info in the script.


Install Add-in and AppleScriptTask file with AppleScript file on your Mac

The example script below will install an Add-in in Excel in the correct folder on your Mac and also an AppleScriptTask file in the correct folder, it will work almost the same as the Add-in example, there is only a new row in this script where you must fill in the AppleTaskScript file name. And also the option to keep the folder with for example your help and example files for the add-in in your add-ins folder if you want, read the info in the script.

05/09/2024
Web design by Will Woodgate