>>Lots of Snip....
>>>
>>>I tried one example. But the error when DDEInitiate is 16.
>>>ie connection error. It asked me to open EXcel sheet or not, but it is not starting the DDE .
>>
>>OK,
>>1) you have built the FP 2.6 app into an .exe
>>2) The .EXE must be 'findable'. Try placing the .EXE in the working directory or somewhere else in the DOS Path, or even better, try using RUN /N (from VFP) or SHELL() ( from VB) to run the exe before you try to connect.
>>3) Your DDEInitiate should use the name of the exe (without .exe) as the service name.
>>4) I'm not sure what the initial Topic should be, the example code should indicate this.
>
>I tried Foxpro as client, and accessed Excel. then the error came.
>I tried using the example for DDEAdvise . And also I gave correct name of .exe without extension along with path.
>
>ie my command is,
>mchannum = DDEInitiate('c:\msoffice\Excel\excel', 'c:\msoffice\excel\examples\sales')
>
>it gave -1 , on checking DDElasterror, gave 16 .
Here's an example that I have just tried. Althought it was a bit slow on the DDEinitiates in NT4 Workstation.
run /n7 "c:\progra~1\Micros~1\Office\Excel.exe"
lnHandle = ddeinitiate("Excel", "System")
? dderequest( lnHandle, "Topics")
? ddeterminate(lnHandle)
lnHandle = ddeinitiate("Excel", "[Book1]Sheet2")
? ddepoke(lnHandle, "R1C1", "=34*45")
? dderequest(lnHandle, "R1C1")
? ddeterminate(lnHandle)