Excel for Mac 2016 AppleScript issue

Question

Microsoft Excel for Mac 2016 version 15.12.3 (150724)

When we try to get the add-ins collection via AppleScript, the application returns the collection with missing values.

The script is as follows:

tell application "Microsoft Excel"

 set addins to add ins

end tell

It returns 

{missing value, missing value, missing value}

Please fix this issue.

Answer 1

Hi Jim,

Thank you for the detailed answer. I've reported this issue using the Smile button.

Answer 2

Hi Renat,

Your question is perfectly clear and understandable. I have instructed Arsad numerous times to not reply to questions that are out of his league, but my pleas have been ignored by Arshad.

Your code will produce "missing value" if there are no add-ins checked under Tools-Addins, which is to be expected.

In Excel 2011 your code responds with a list of the add-ins that have been chosen under Tools-Add-ins. In my testing the response was correct: 

{add in "Solver.xlam" of application "Microsoft Excel"}

In Excel 2016 your code responds with {missing value, missing value, missing value} regardless of which add-ins are active. I am certain that this is the situation you wish to report. This is a bug.

The folks who populate these forums are just Excel users like you and me. None of us have the power to fix the problem. If you wish to alert Microsoft to this bug, use the Smile button in the upper right part of the Excel 2016 screen. Those submissions go to Microsoft.

Answer 3

Can you upload a screenshot of the issue.

Also exact steps to reproduce the issue would be helpful.

Arshad, please stop this nonsense.

The question already provides enough information to be answered. You wasted this good person's time requesting a screen shot.

When you do not know the answer to a question DO NOT REPLY. Leave the question unanswered. You've been asked repeatedly to stop posting irrelevant answers.

Answer 4

Sure, here it is:

1. Start Excel.
2. Start Script Editor.
3. Add script:

tell application "Microsoft Excel"

 set addins to add ins

end tell

4. Run script.

Answer 5

Can you upload a screenshot of the issue.

Also exact steps to reproduce the issue would be helpful.