I have been asked to create a solution to open a specific workbook that contains TR Eikon information that is being queried using the TR Eikon Add-in in Excel.
I have created a wrapper workbook that will open the workbook in question and refresh the data. After the refresh it save a copy of one of the sheets in the workbook for future reference.
I have tested this by manually opening the wrapper sheet and this works fine. The source worksheet is loaded, the TR Eikon addin logs in succesfully and data is refreshed.
When I do this using a scheduled task when the user is not logged in, the TR Eikon addin does not login, status remain Waiting for Login (as checked with the PL Sync Manager API) eventhough the user that is used to run the scheduled task is the same user as the one I used for manual testing, so credentials should be available for TR Eikon addin to login.
Is it possible to run Excel in the background and login to TR Eikon addin via a scheduled task or does this always needs to be run under a logged user?