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