Hi Hays,

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 this fashion.

I hope this is clear!

Joe.

---------- : 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 : RUN; : : If I record a macro to do this, it writes the visual basic code to do : it. : Can this code be used somehow to send commands through DDE? : : Visual basic code is: : Sub Macro1() : Range("A3:B5").Select : Selection.ClearContents : End Sub : : Thanks for any help. : : --Hays McLean