RE: DDE-Problem

Hello John,
 
Your best bet is to use DDEExecute with the GET.FORMULA function.  This will return the contents of the cell specified to a variable in your Genero program.
 
e.g.
 
CALL ui.INTERFACE.frontCall("WINDDE", "DDEExecute", ["EXCEL", filename_variable, "[get.formula(\"R1C1\")]"], [return_variable])
 
The contents of cell R1C1 will be returned to "return_variable"
 
Hope that helps.
 
Marcus Lim
Support Analyst/Programmer
Haden Young Limited
Winners of Building Services Awards Health & Safety Initiative of the Year 2005 

Tel: 01923 295043
Fax: 01923 295108
Email: [email protected] <mailto:[email protected]> 
Web Site: www.hadenyoung.co.uk <http://www.hadenyoung.co.uk/>  

This email may contain information which is confidential and is intended only for use of the recipient/s named above. If you are not an intended recipient, you are hereby notified that any copying, distribution, disclosure, reliance upon or other use of the contents of this email is strictly prohibited. If you have received this email in error, please notify the sender and destroy it.

The company does not provide advice, opinion or enter into any form of contract using Email or any attachment accompanying it.

 


________________________________

From: [email protected] [mailto:[email protected]] On Behalf Of John Borders
Sent: 13 March 2006 16:32
To: [email protected]
Subject: 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] <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/> 

		 

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