AW: DDE-Problem

I have the answer by now & since my excel runs in

German, I have to use "Z1S1" instead of "R"ow and "C"olumn,

 

Thank you anyway

 

________________________________

Von: [email protected] [mailto:[email protected]] Im Auftrag von Tim Bell
Gesendet: Montag, 13. März 2006 13:34
An: [email protected]
Betreff: RE: [fourjs-users] DDE-Problem

 

Isn't the second parameter of DDEConnect & DDEPoke the sheet name (ie Sheet1), not the file name?

 

Tim

 

________________________________

From: [email protected] [mailto:[email protected]] 
Sent: 13 March 2006 12:00
To: [email protected]
Subject: [fourjs-users] DDE-Problem

Dear all,

We have a problem concerning DDE within Genero -

Here I have the simple code,

which opens the "empty1"-Excelsheet

and displays "rc1=1" and "rc2=1",

but does not alter the specified cell in Excel - Why not ???

 

LET l_rc  = WinExec("C:\\\\programme\\\\microsoft office\\\\office11\\\\Excel C

:\\\\empty1.xls")

 

LET l_rc  = DDEConnect("Excel","empty1.xls")

display "rc1=", l_rc

 

LET l_rc = DDEPoke("Excel","empty1.xls","R1C1","hallo")

display "rc2=", l_rc

 

CALL DDEFinishAll()

 

Thank you very much in advance,

 

Best regards / Mit freundlichen Grüßen

 

 Gerhard Neu

Senior Consultant

____________________________

 

IDS Scheer Austria GmbH
Tel.: +43 70 750951 12

Mobil: +43 664 611 8065
Fax: +43 1 79566 28065

E-Mail: [email protected] <mailto:[email protected]> 
Kirchmühlstrasse 26

A - 4040 Linz
____________________________

Business Process Excellence

 

SAP Global Services Partner

 

****************************************************************

AGILITY & EXECUTION

Driven By ARIS Business Process Management

 

Seien Sie Gast der ProcessWorld Europe ´06

vom 18.-19. Mai 2006

und des ARIS User Day ´06

am 17. Mai 2006

im Conference Center RAI in Amsterdam

 

Weitere Informationen unter:

www.processworld.com <BLOCKED::http://www.processworld.com/> 

 

****************************************************************

 

**********************************************************************

For full detailed disclaimer please visit http://www.ocs.co.uk/exec/Notice_&_Disclaimer