Using DDE to open a password protected Spreadsheet

[Doyleuk]

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;

[Doyleuk]

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;