07-31-2012 05:42 PM
whrer I can find the whole list of command help for SAS-Excel DDE ? such as what 's the meaning of "put '[error(false)]';?"
I didn't find a detail introduction of all these commands.
filename cmds dde 'excel|system';
/* Insert an graph */
/* Insert an Excel Macro Sheet */
07-31-2012 06:10 PM
DDE is basically using really old excel commands that are documented here
They're excel 4.0 macro functions and NOT SAS functions.
08-01-2012 09:22 AM
Thank you,I download the macrofun file and found the help for my question:
Enable_logical is a logical value or number that selects or clears error-checking.
If enable_logical is FALSE or 0, all error-checking is cleared. If error-checking is cleared and an error is encountered while a macro is running, Microsoft Excel ignores it and continues. Error-checking is selected again by an ERROR(TRUE) statement, or when the macro stops running.
Type_num specifies the type of sheet to insert.
Type_num Type of sheet
3 Excel 4 Macro Sheet
4 Excel 4 International Macro Sheet
6 Microsoft Excel Visual Basic Module
quoted text Template
If omitted, the type of the active sheet is used.
If the current selection contains one sheet, then only one sheet is inserted. If the selection contains more than one sheet and the active sheet is a worksheet, then an equal number of sheets is inserted to the left of the selected group of sheets.
Also ,I get another question:
Could we use our user defined excel macro in the put  command? that would be very interesting. I will try this later.
07-31-2012 06:34 PM
The macrofun helpfile, that Fareeza pointed you to, is the official documentation. You can find a lot of SAS-related insights, though, if you read Koen Vyverman's papers. You can find them at: Koen Vyverman: SAS Related Papers