|Date: ||Wed, 2 Jul 1997 19:32:50 +0100|
|Reply-To: ||Joe Clarke <josephclarke@TINET.IE>|
|Sender: ||"SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>|
|From: ||Joe Clarke <josephclarke@TINET.IE>|
|Subject: ||Re: Help using Excel DDE Commands|
|Content-Type: ||text/plain; charset=ISO-8859-1|
DDE statements to be passed to Excel are written in Excel version 4 Macro
language. There is an option on "record macro" in Excel to record it in
Excel 4 format. By then looking at the macro's statements, you can paste
these to your SAS program, into your put statements. I can't remember
offhand what the command for clear is, but you should be able to find it in
I hope this is clear!
: From: Hays McLean <Hmclean@peach.fruit.com>
: To: Multiple recipients of list SAS-L <SAS-L@UGA.CC.UGA.EDU>
: Subject: Help using Excel DDE Commands
: Date: 02 July 1997 15:34
: I am trying to write some SAS code that executes some commands in an
: Excel spreadsheet. I have done this a lot with Lotus but need some help
: with the commands to use for Excel.
: The following is simply to select a range and clear it. The clear
: doesn't work and I've tried several alternatives.
: FILENAME CMDS DDE 'EXCEL|SYSTEM';
: DATA _NULL_;
: FILE CMDS;
: PUT '[SELECT("rangename")]';
: ===> PUT '[CLEAR()]'; <===== doesn't work
: If I record a macro to do this, it writes the visual basic code to do
: Can this code be used somehow to send commands through DDE?
: Visual basic code is:
: Sub Macro1()
: End Sub
: Thanks for any help.
: --Hays McLean