Zip Excel File With Password from SAS

[AlboMrsP]

Hi,

I'm currently trying to zip and password protect an excel file I output on a monthly basis so I can then auto email it to the relevant recipients.

I've tried playing around with DDE and a few other bits I've found on the internet, but, to no avail :-(

Does anyone have any idea how to do this? and if it is possible without the use of DDE?

If the file can't be zipped then just a passworded Excel file would be sufficient...

Thank you loads for any advice you may have

 

[jj72uk]

Hi,

On the SAS knowledge base there's this example on password protecting excel files via DDE:

http://support.sas.com/kb/31/328.html

And for Zipping up files again another SAS help file:

http://www2.sas.com/proceedings/sugi29/077-29.pdf

The above zip example will need to be modified if its just a single file.

 

[AlboMrsP]

Thanks JJ72uk for this info.

I've managed to get the Excel passwording to work, but, not the zipping :-(

I've tried the below code, but, it doesn't work.


%let report1 = c:\sas outputs\Data &prev_yrmth.;
%let filename = %sysfunc(compress(&report1));

data _null_;
put '"crogram files\winzip\winzip32.exe"' "&filename" '.zip ' "&filename" '.xls';
run;

Do you know how to adapt this to work?

Thanks again

 

[jj72uk]

Well..

What error are you getting?

Also ...

Aren't you missing a \

put '"c:\program files\winzip\winzip32.exe"' "&filename" '.zip ' "&filename" '.xls';

 

[AlboMrsP]

I fixed it - needed the code to be on a single line.

Yeah, I had a \ missing. It's back in and working fine now.

Thanks for all your help.