topic Re: Where I can find DDE reference help for SAS and excel DDE? in SAS Procedures

Where I can find DDE reference help for SAS and excel DDE?

Mike_Davis — Tue, 31 Jul 2012 21:42:12 GMT

Hello everyone;

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.

Thanks

Mike

filename cmds dde 'excel|system';

data _null_;

file cmds;

/* Insert an graph */

put '[workbook.insert(2)]';

run;

data _null_;

file cmds;

/* Insert an Excel Macro Sheet */

put '[workbook.insert(3)]';

run;

Re: Where I can find DDE reference help for SAS and excel DDE?

Reeza — Tue, 31 Jul 2012 22:10:19 GMT

DDE is basically using really old excel commands that are documented here

http://support.microsoft.com/kb/128185

They're excel 4.0 macro functions and NOT SAS functions.

Re: Where I can find DDE reference help for SAS and excel DDE?

art297 — Tue, 31 Jul 2012 22:34:09 GMT

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

Re: Where I can find DDE reference help for SAS and excel DDE?

Mike_Davis — Wed, 01 Aug 2012 13:22:20 GMT

Thank you,I download the macrofun file and found the help for my question:

ERROR(enable_logical, macro_ref)
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.

WORKBOOK.INSERT(type_num)
WORKBOOK.INSERT?(type_num)
Type_num specifies the type of sheet to insert.

Type_num Type of sheet

1 Worksheet
2 Chart
3 Excel 4 Macro Sheet
4 Excel 4 International Macro Sheet
5 (Reserved)
6 Microsoft Excel Visual Basic Module
7 Dialog
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.

Thanks

Mike