Date:         Fri, 11 Dec 1998 12:43:40 -0500
Reply-To:     "Mendicino, Tom" <TMendicino@FLEETCC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Mendicino, Tom" <TMendicino@FLEETCC.COM>
Subject:      Question for OLE proponents
Content-Type: text/plain

I have seen several postings decrying DDE as the equivalent of making marks
on tree bark with a burnt stick, while extolling the virtues of OLE.  A
question for you.  In DDE, I can iteratively write data to an Excel
spreadsheet from within a datastep. I can also send commands to the
excel|system topic, formatting my output exactly the way I want it.  I have
complete control over the spreadsheet from within SAS.  How can I accomplish
this using OLE?  In OLE, the best I can come up with on my own is creating a
CSV file and opening it in Excel,  then using VBA to format the spreadsheet,
and I had to use a VB interface to do it.  I assume I am missing something.
Can someone please point me in the right direction to accomplish these tasks
from within SAS using OLE?
 
TIA
 
 
                _/_/_/_/_/_/_/_/_/_/_/_/_/
              _/_/      Tom Mendicino     _/_/
            _/_/       (215) 444-3774   _/_/
          _/_/_/_/_/_/_/_/_/_/_/_/_/