AW: 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] <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/> 

	 

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