Detecting MS excel is open in Citrix via Lotus Script

30 pts.
Tags:
Citrix
Lotus Notes 6.x
Lotus Notes Database
LotusScript
Microsoft Excel
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following