>Date: Tue, 11 Feb 1997 16:45:
>To: hpvxd_xc@hpislsup.lvld.hp.com
>From: "bjarne e. roscher" <bjarne.roscher@ffhs.uib.no>
>Subject: Vrf: need help DDE and excel.
>
>Dear VEE users!
>I tryed to transfer a 1D Array Int32 [400] with >To/From DDE< to MS Excel.
>
>In the Open View area i selected:
>---------------
>Excel
>Ark1 /*norwegian
>5
>
>Write Item "r1" Text a REAL STD EOL
>
>-------------
>
>in the Properties tab i selexted
>
>-------------
>Data only
>
>Block
>
>-------------
>
>
>When i now start the program, the whole Array (or better a part of it -
until overflow) is written to the cell A1.
>What i want is that each Arrayvalue gets its own cell, prefeard vertically
(A1-A400).
>
>Have You got any idea how i could do that??
>
>Thanks in advance!
>
>Yours
>Bjarne Roscher
>
Bjarne Erik Roscher
Haukeland Sykehus
Dept. of Clinical Engineering
N-5021 Bergen
Tel: w: ++4755973038
p: ++4790511903 from 4.3.97 ++4994182791
E-Mail: b.roscher@euromail.com
bjarne.e.roscher@medtek.haukeland.no
WWW: http://www.juelich.fh-aachen.de/~wikinger
>To: hpvxd_xc@hpislsup.lvld.hp.com
>From: "bjarne e. roscher" <bjarne.roscher@ffhs.uib.no>
>Subject: Vrf: need help DDE and excel.
>
>Dear VEE users!
>I tryed to transfer a 1D Array Int32 [400] with >To/From DDE< to MS Excel.
>
>In the Open View area i selected:
>---------------
>Excel
>Ark1 /*norwegian
>5
>
>Write Item "r1" Text a REAL STD EOL
>
>-------------
>
>in the Properties tab i selexted
>
>-------------
>Data only
>
>Block
>
>-------------
>
>
>When i now start the program, the whole Array (or better a part of it -
until overflow) is written to the cell A1.
>What i want is that each Arrayvalue gets its own cell, prefeard vertically
(A1-A400).
>
>Have You got any idea how i could do that??
>
>Thanks in advance!
>
>Yours
>Bjarne Roscher
>
Bjarne Erik Roscher
Haukeland Sykehus
Dept. of Clinical Engineering
N-5021 Bergen
Tel: w: ++4755973038
p: ++4790511903 from 4.3.97 ++4994182791
E-Mail: b.roscher@euromail.com
bjarne.e.roscher@medtek.haukeland.no
WWW: http://www.juelich.fh-aachen.de/~wikinger
gvg@lvld.hp.com / 970-679-3030 / FAX 970-679-5971
to: VRf-Bjarne Roscher
date: Tuesday, 11 February 1997 0910 MST
> When i now start the program, the whole Array (or better a part of it -
> until overflow) is written to the cell A1.
> What i want is that each Arrayvalue gets its own cell, prefeard vertically
> (A1-A400).
>
> Have You got any idea how i could do that??
At a guess, I think you want to have a line-feed array separator character
defined when you output the array.
Please let me know how this works.
> Thanks in advance!
>
> Yours
> Bjarne Roscher
> Bjarne Erik Roscher
> Haukeland Sykehus
> Dept. of Clinical Engineering
> N-5021 Bergen
>
> Tel: w: ++4755973038
> p: ++4790511903 from 4.3.97 ++4994182791
>
> E-Mail: b.roscher@euromail.com
> bjarne.e.roscher@medtek.haukeland.no
> WWW: http://www.juelich.fh-aachen.de/~wikinger
[<>] regards -- gvg