Help using Base SAS procedures

DDE Code

Reply
N/A
Posts: 0

DDE Code

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
Regular Contributor
Posts: 151

Re: DDE Code

Posted in reply to deleted_user
N/A
Posts: 0

Re: DDE Code

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
Regular Contributor
Posts: 151

Re: DDE Code

Posted in reply to deleted_user
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;
Ask a Question
Discussion stats
  • 3 replies
  • 260 views
  • 0 likes
  • 2 in conversation