RE: DDE-Problem

Hello Gerhardt.

I don't understand what you really mean but you e.g. also use (in German):

Z1S1:Z1S22

Henk

  -----Oorspronkelijk bericht-----
  Van: [email protected] [mailto:[email protected]]Namens
Neu, Gerhard
  Verzonden: maandag 13 maart 2006 13:38
  Aan: [email protected]
  Onderwerp: AW: [fourjs-users] DDE-Problem


  Thank’s a  lot,

  S1Z1 was a good clue – But it only works with Z1S1 !?



  Thank you very much again !!!




----------------------------------------------------------------------------
--

  Von: [email protected] [mailto:[email protected]] Im
Auftrag von H.J. Sanders
  Gesendet: Montag, 13. März 2006 13:21
  An: [email protected]
  Betreff: RE: [fourjs-users] 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



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