RE: DDE-Problem

Hello Gerhardt.

2 remarks from our practice:

The DDEConnect can take quit awhile so do something like:

while not DDEConnect .......
        sleep 1
end while


Next Excel is language sensitve, so assuming you have set up Excel to run in
German you have to use
S for the column and Z for the row so "S1Z1"

Good luck

Henk Sanders


  -----Oorspronkelijk bericht-----
  Van: [email protected] [mailto:[email protected]]Namens
Neu, Gerhard
  Verzonden: maandag 13 maart 2006 13:00
  Aan: [email protected]
  Onderwerp: [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]
  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



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