I'm editing a c# program which uses System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application") to get the active Excel worksheet and passes Excel.Application object to several functions.
This runs fine when the application is on the desktop, but if it is run from Citrix, it doesn't see the Excel app that is open on the client desktop. For various reasons we have to access the sheet on the client desktop - they can't run excel in citrix.
Any suggestions as to how to get the Excel.Application object running on the client destop?
Thanks in advance!