BookmarkSubscribeRSS Feed
Doyleuk
Calcite | Level 5
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;
1 REPLY 1
Doyleuk
Calcite | Level 5
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;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 3731 views
  • 0 likes
  • 1 in conversation