Excel Add-in randomly unloaded from user profile

robnjay

New Member
Joined
Sep 9, 2005
Messages
9
I have an Excel Add-in which I created sometime back that is being used to automate some fancy reports that are published as HTML.

This Add-in is loaded into Excel in a special Windows user profile that has a password which does not expire (locked down to the machine where the reports are generated). So this "automation user" has the add-in loaded in its Excel.

We are using Arcana Scheduler to open the report spreadsheets as the "automation user". VBA in each spreadsheet causes the spreadsheet to close after its reports are generated and published.

This works flawlessly for weeks (or months) at a time. Then without warning, the add-in is unloaded from the "automation user" profile and the automation fails.

I can then open any spreadsheet as "automation user", go to Tools>Add-ins, and see that my add-in is unchecked in the list. I can then check the checkbox for this add-in (which never disappears from the list) and everything will work for weeks (or months).

Does anyone have any ideas why this is happening?
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Forum statistics

Threads
1,137,202
Messages
5,680,145
Members
419,886
Latest member
Pulpboi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top