DDE Code

[deleted_user]

Hi All,

Im looking to get a better understanding of using DDE to open an excel spreadsheet that has a password.

Once the Excel is open, export a file and then close excel.

My understanding of SAS is limited as I'm new and would like to uderstand how this can be done.

regards

[Oleg_L]

Hello.

You may find this thread useful.


http://support.sas.com/forums/thread.jspa?messageID=35783诇

>

http://support.sas.com/forums/thread.jspa?messageID=35783诇

[deleted_user]

hi thanks for the reply,
I have a question, in the below line is "cc" file name that I'm trying to open?

filename cc dde 'Excel|System';

regards

[Oleg_L]

Hello.
Yes, "cc" is a filename by which you manage Excel in the datastep:

data _null_;
file cc; put '[Open("c:\documents\wg.xls",0,1,,"abcdxxx")]';
run;