Excel Add-in not working when MS opens Excel

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
stearno
Junior Coder
Posts: 22
Joined: Sun Jul 26, 2020 4:15 am

Excel Add-in not working when MS opens Excel

Post by stearno » Tue Mar 02, 2021 5:30 am

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.
Image
https://ibb.co/rbcPpjy

But when Macro Scheduler opens Excel, it does not show the add-in.
Image
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!

User avatar
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

Post by Dorian (MJT support) » Tue Mar 02, 2021 11:13 am

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

stearno
Junior Coder
Posts: 22
Joined: Sun Jul 26, 2020 4:15 am

Re: Excel Add-in not working when MS opens Excel

Post by stearno » Tue Mar 02, 2021 2:15 pm

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

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts