topic DDE Code in SAS Procedures

DDE Code

deleted_user — Mon, 28 Mar 2011 23:44:04 GMT

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

Re: DDE Code

Oleg_L — Tue, 29 Mar 2011 05:28:43 GMT

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诇

Re: DDE Code

deleted_user — Thu, 31 Mar 2011 01:09:01 GMT

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

Re: DDE Code

Oleg_L — Thu, 31 Mar 2011 05:12:05 GMT

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;