Read value from preference file
Sometimes as a developer you want to know what is in your com.microsoft.Excel.plist file.
The example below will only work when you use the new AppleScriptTask function in Excel 2016 and higher. Below you will find the Appelscript that you must save into a script file named ReadPlistValue and copy it in the correct location, and the VBA macro that you can use to run the script.
Follow the steps from this page to get it working : How to use AppleScriptTask in Mac Office
The example below will only work when you use the new AppleScriptTask function in Excel 2016 and higher. Below you will find the Appelscript that you must save into a script file named ReadPlistValue and copy it in the correct location, and the VBA macro that you can use to run the script.
Follow the steps from this page to get it working : How to use AppleScriptTask in Mac Office
The Applescript
The VBA macro
See also this page if you want to save/read information to/from your own plist files.
SaveSetting, GetSetting and DeleteSetting on Mac