Mike and Charles,

Thank you very much for your replies. I tried both suggestions. In each
case, the command I wish to execute within EXCEL is written into the cell as
text. This means I'm getting there, but with the wrong action --- an
improvement. You got me onto the right track!

Brad McClarren

From: "Mike Ghan" <mikeg_at_logix-controls.com>
To: <sftalk_at_forth.com>
Sent: Monday, December 04, 2000 4:15 PM
Subject: [sftalk] XTYP_EXECUTE, DdeClientTransaction, and EXCEL

> I believe VBA (Visual Basic for Apps) prefers caps for the range. Try
>
> Z\" WORKSHEETS(\"SHEET1\").Range(\"A1:C1\").Font.ColorIndex=3"
>
> I've not tested this, but our VBA guy believes this will take care of
> it.
>
> Hope it helps,
>
> Mike

----- Original Message -----
From: "Charles Melice" <mail_at_forthcad.com>
To: <sftalk_at_forth.com>
Sent: Monday, December 04, 2000 5:13 PM
Subject: Re: [sftalk] XTYP_EXECUTE, DdeClientTransaction, and EXCEL

> On Mon, 04 December 2000, "Brad McClarren" wrote:
>
> [...]
>
> > : DDE-EXECUTE ( addr n -- )
> > ( a n) CONV HITEM CF_TEXT XTYP_EXECUTE 5000 0 DdeClientTransaction
> > DdeFreeDataHandle DROP ;
>
> [...]
>
> > Anybody have a pointer or two?
>
> Try the following: ( just "1+" appended )
>
> : DDE-EXECUTE ( addr n -- )
> ( a n) 1+ CONV HITEM CF_TEXT XTYP_EXECUTE 5000 0 DdeClientTransaction
> DdeFreeDataHandle DROP ;
>
> Regards,
> Charles Melice
>
>
>
> _______________________________________________
> Sftalk mailing list Sftalk_at_forth.com
> Visit Sftalk on the web at http://www.forthinc.com/mailman/listinfo/sftalk
Received on Tue Dec 05 2000 - 04:44:32 PST