How to detect tasks loaded in Citrix session?
I need an output that will produce graphs using Excel data stored in a database in Lotus Notes. Once the graphics are composed in Excel, copied and pasted into a rich text field in Lotus Notes which is displayed to the user so that the user will not look everything in the Excel.
But if Excel is already loaded by the user when Lotus Script starts depending on the amount of data in the graph, there is not enough memory available to copy and paste the graphic into Lotus Notes. To address this, I wrote a code that is downloaded from Excel before executing the graphing process that works well.
However, the closing method was completing the Excel session without prompting the user to confirm the saving of any calculation or open books resulting in potential data loss. So I created a new function now that will check for stand and ask the user to close Excel manually before proceeding with the graphical representation.
Now this works fine on a PC or laptop when the user has a local version of Lotus Notes, but not when the user logs on to Lotus Notes through Citrix account. Excel is always in Citrix reporting as active although not in the Windows Task Manager. Do you know how to detect all tasks loaded on a Citrix session? So you can correctly identify whether Excel is loaded or not.