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!
Excel Add-in not working when MS opens Excel
Moderators: Dorian (MJT support), JRL
- Dorian (MJT support)
- Automation Wizard
- Posts: 1348
- Joined: Sun Nov 03, 2002 3:19 am
- Contact:
Re: Excel Add-in not working when MS opens Excel
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
Re: Excel Add-in not working when MS opens Excel
Perfect. Yes that worked! Thank you for the advice.