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?
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?