DDE Question (OpenInsight) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{tag>category:"OpenInsight" author:"Richard Richter" author:"Oystein Reigem"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== DDE Question (OpenInsight) ====
=== At 16 AUG 2001 10:05:26AM Richard Richter wrote: ===
 
 
<QUOTE>
Does anybody know if it's possible to send the Excel Command "Data/Refresh Data" from within an OIS event. I know how to do Save and Quit, but is there a secret code to run the Web Query?



Thanks,

Richard Richter
</QUOTE>
----

=== At 17 AUG 2001 04:07AM Oystein Reigem wrote:  ===

<QUOTE>Richard,



Perhaps you have to do it via a macro.



First make an Excel macro that performs whatever it is you want Excel to do. (Other must tell you where to store the macro.)



Then run that macro with DDE.



Here is something similar I think I got to work with Word. Makro1 is the name of my macro. (I don't remember what all that DDEERROR fuss was about):



declare function Set_Property

Void=Set_Property( @Window, "DDESERVICE", 'WINWORD' )

DDESERVICEError=***"

DDESERVICEError=Get_Property( @Window : ".DDE", "DDEERROR" )

Void=Set_Property( @Window, "DDECOMMAND", 'FileOpen .Name=c:\winR\Arbeid\OIdes99v.doc"' )

DDECOMMANDError=***"

DDECOMMANDError=Get_Property( @Window : ".DDE", "DDEERROR" )

Void=Set_Property( @Window, "DDECOMMAND", 'Makro1()' )

DDECOMMAND2Error=***"

DDECOMMAND2Error=Get_Property( @Window : ".DDE", "DDEERROR" )

Void=Set_Property( @Window : ".RES", "TEXT", DDESERVICEError : "/" : DDECOMMANDError : "/" : DDECOMMAND2Error )



- Oystein -

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=10626BEB944A7D7B85256AAA004D66E5|View this thread on the Works forum...]]