Excel Add-in not working when MS opens Excel

[stearno]

I don't know if this is something you can help with, but I have tried for 2 days and cannot figure a solution.

When I open Excel myself, it shows the add-in SpeedTools.

https://ibb.co/rbcPpjy

But when Macro Scheduler opens Excel, it does not show the add-in.

https://ibb.co/JtrgDcV

I require this add-in as it does calculations before my MS macro can finish its program.

I have already done in the Trust Center "trusted VBA" and "enable all macros". I have even checked after MS opens excel, the add-in is enabled. Also, I have repaired MS Office.

I appreciate any advice!

[Dorian (MJT support)]

Although I can't explain why the add-on might not be loading, I can suggest a workaround. What happens if you use ExecuteFile to launch Excel? Does the add-on load? Then you can use XLGet (added Version 14.4 04/10/2017) to assign the book handle, and continue as normal.

Code: Select all

executefile>d:\hours.xlsx
waitwindowopen>hours.xlsx*

XLGet>d:\hours.xlsx,xlbook
XLGetCell>xlbook,Sheet1,2,2,CellB2

[stearno]

Perfect. Yes that worked! Thank you for the advice.