RE: DDE

"Marcus Lim" <[email protected]> Fri, 28 Apr 2006 17:03:55 +0100
Newsgroups gmane.comp.lang.4gl.fourjs.user
Message-ID <[email protected]>
 
I find it's better to use DDEExecute and use the function Get.Formula()
to get the contents of a cell.
 
e.g.
 
CALL ui.INTERFACE.frontCall("WINDDE", "DDEExecute", ["EXCEL",
filename_variable, "[get.formula(\"R1C1\")]"], [return_variable])
 
Hope that helps.
 
Regards,
 
Marcus Lim
 


________________________________

From: [email protected] [mailto:[email protected]] On
Behalf Of Neu, Gerhard
Sent: 28 April 2006 14:25
To: [email protected]
Subject: [fourjs-users] DDE



Here is my (4JS-)problem:

 

I have an open Excel-sheet (german-version)

called "Mappe1" -

DDEPoke works fine, but

DDEPeek  produces the following error (DDEGetError()):

 

invalid command name "ddeExcel_Mappe1"

 

Code:

LET str50 = DDEPeek("Excel","Mappe1","Z3S2")

 

Can anyone help me ???