Creating an excel Spreadsheet via LotusScript

30 pts.
Tags:
Citrix
Lotus Notes
Lotus Notes 6.x
Lotus Script
I have created some code to create a series of MS Excel 2010 graphs using LotusScript then copy and paste them into a Lotus Notes Document. The Excel application is launched int he background so that the user only sees their notes session and not distracted by the excel application.

In order to keep things simple. (I thought). I have attached the Lotus Notes Template with all the charts definition onto a lotus Notes document in my database and this gets launched and data added to cells in order to render the predefined graphs.

In order for the excel application to launch the spreadsheet. I have to detatch it to the os file system then open it in my code.

HOME_DRIVE = "H"

Call o.ExtractFile(HOME_DRIVE & "" & o.Name)      Set xlApp =CreateObject("Excel.Application")          Call xlapp.Workbooks.Open (HOME_DRIVE & "" & o.name, 3)

However, the code works perfectly well when it's on a computer/laptop on with a local copy of Lotus Notes. But it seems to be problematic when a user accessing Lotus Notes via Citrix tries to run the application. Citrix is where all end users access Lotus Notes.

So my question is how do I modify my code so that it can detect whether the user is in citrix or not and identify a drive where it can detatch and launch the Excel spreadsheet from?

 

Thanks

Vince

 

 

 

However this works perfectly well on a local computer/laptop with the notes client installed on the computer.

However



Software/Hardware used:
Lotus Notes R6.5
ASKED: September 15, 2011  4:23 PM
UPDATED: March 31, 2012  4:24 PM

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