I have an application that generates graphs using excel from data stored in a Lotus Notes Database. Once the graphs are created in excel,they are copied and pasted into a Rich Text Field in Lotus notes which is then displayed to the user so that the user never sees excel at all. However. If excel is already loaded by the user when lotusscript runs then depending on the amount of data in the graph, there is insufficient memory available to copy and paste the graph into Lotus Notes. To deal with this I wrote some code that unloads excel before running the graphing process which works fine. However the closing process was just terminating the excel session without asking the user to confirm saving of any open spreadsheets or workbooks resulting in a potential loss of data. So I've created a new function that will now check for the existence of excel and then ask the user to close excel manually before I proceed with graphing. Now this works fine on a pc or laptop when the user has a local version of Lotus Notes but not when the user is logged into Lotus notes via their Citrix account. In citrix excel is always reporting as being active even though it is not showing in the windows task manager. Do you know anyway of detecting loaded tasks in a citrix session so I can correctly identify whether excel is loaded or not. Thanks Vince
Software/Hardware used: Lotus Notes R6.5, MS Office 2010
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!