-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Eike Rathke wrote:
> Hi Davide,
>
> On Mon, Jul 25, 2005 at 08:26:07 +0200, Davide Dozza wrote:
>
>
>>We've a SAS application which populates an Excel document using DDE.
>
>
> How is that achieved on the Excel side?
Is it activate from the server side? I figured out it's a push procedure
toward excel not a pull from SAS.
Anyway, here is a piece of code:
submit
filename cmds dde 'Excel|system';
data _null_ ;
file cmds;
select = '[select("' || "&rows.1&cols.1:&rows.&nrows1&cols.&ncols"
|| '")]';
put select ;
put "[column.width(,,,3)]";
put select ;
put "[app.activate()]" ;
run ;
endsubmit
>
>
>>We need to translate such procedure in order to populate a Calc document
>>in the same way.
>>
>>The question is: how much is DDE standard enough in order to reuse the code?
>
>
> In general it shouldn't be a problem if your application is a DDE server
> with some kind of standard behavior, even if there is no standard for DDE ...
>
> While the Excel formula syntax is =program|topic!data
> in OOoCalc it is =DDE("program";"topic";"data")
>
> There may be differences though how arriving data is interpreted.
> OOoCalc's DDE() function supports an additional parameter for how
> numbers are to be interpreted, see the online help topic "DDE function".
If I understand well, SAS application should operate as DDE server while
Excel has to pull data from it. Correctly? Are there any other possible
way?
Davide
>
> Eike
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFC5ll2IXgZqRs8KhMRAgKaAJ94e0ePdawbDsY2ubLA2MHOHOvIgwCfcIFI
pebu6RTBrTSiFYOwY7TEG3w=
=wV9N
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
