Help using Base SAS procedures

Using DDE to open a password protected Spreadsheet

Reply
Occasional Contributor
Posts: 12

Using DDE to open a password protected Spreadsheet

Hi,

I am lookin to open a password protected spreadsheet via SAS using DDE.

My code below runs perfect for opening non password protected spreadsheets.

Can anyone please help me amend my code to include the password parameter within my code.

options noxwait noxsync;
x '"C:\Program Files\Microsoft Office\Office\EXCEL.EXE"';

data _null_;
x=sleep(10);
run;

filename cmds dde 'excel|system';

data _null_;
file cmds;
put '[Open("\\Datal0047\Clientserv\SAS\Devt\daniel\excel\Test1.xls")]';
run;
Occasional Contributor
Posts: 12

Re: Using DDE to open a password protected Spreadsheet

Hi,

I have managed to get an answer from another source.

Its coded below for any others you require it.

options noxwait noxsync;
x '"C:\Program Files\Microsoft Office\Office\EXCEL.EXE"';

data _null_;
x=sleep(10);
run;

filename cmds dde 'excel|system';

data _null_;
file cmds;
put '[Open("\\Datal0047\Clientserv\SAS\Devt\daniel\excel\Test1.xls",,,,"'"test123"'")]';
run;
Ask a Question
Discussion stats
  • 1 reply
  • 1327 views
  • 0 likes
  • 1 in conversation