Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COM Automation on a Remote User
Message
From
08/09/2011 03:03:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
COM Automation on a Remote User
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01522969
Message ID:
01522969
Views:
100
Hi All,

We have an application running on a server to which we allow users remote access via terminal services / remote desktop. Our application has a facility where it automate Excel to create and populate a spreadsheet with data. This is done via
  TOBJ_XLS = CREATEOBJECT( "Excel.Application" )
However, under terminal services / remote desktop this would instantiate Excel on the server and we obviously don't want that. We want the Excel to be instantiated on the client machine. Under VFP help I find this command:
  CREATEOBJECTEX(cCLSID | cPROGID, cComputerName [, cIID])
and, if I understand this correctly, it appears that this command can be used to instantiate an object reference to Excel on the user's machine. Is that right? If so, how do I determine the value of the parameters required? Does SYS(0) help me? Any advice very welcome.

TIA
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Next
Reply
Map
View

Click here to load this message in the networking platform