AW: DDE-Problem

Perhaps  his Excel is in ‚austrian’ ?

Everybody knows, ‘austrian german’ is a funny language ;-)

 

Georg

 

  _____  

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

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

 

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