RE: DDE-Problem

Hello John.

Sorry, but our experience is only one way:  4JS to Excel, not reverse.

Henk

  -----Oorspronkelijk bericht-----
  Van: [email protected] [mailto:[email protected]]Namens
John Borders
  Verzonden: maandag 13 maart 2006 17:32
  Aan: [email protected]
  Onderwerp: RE: [fourjs-users] DDE-Problem


  Mr Neu & Mr Sanders,



  Since you are both very familiar with DDE, I have a related – but
reverse – question.

  I would like to prepare data for entry in an Excel spreadsheet, then
activate DDE so that the data is ‘automatically’ entered into the
appropriate field(s) on a Genero form.



  For example, if I have an excel listing of employee numbers and telephone
numbers, I would like to run a DDE that would take an employee number from
the excel spreadsheet and enter it into Genero a particular data-entry box
in our Genero GUI, then find that particular employee record in Genero, and
then take the telephone number from excel and enter that in the appropriate
data-entry box in Genero.



  Thank you.

  John Borders


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

  From: [email protected] [mailto:[email protected]] On
Behalf Of H.J. Sanders
  Sent: Monday, March 13, 2006 10:51 AM
  To: [email protected]
  Subject: RE: [fourjs-users] 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



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