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

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 -

View this thread on the Works forum...