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

		 

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