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.
But when Macro Scheduler opens Excel, it does not show the add-in.
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!
Technical support and scripting issues
3 posts • Page 1 of 1
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
Yes, we have a Custom Scripting Service. Message me or go here