Password Protecting an Excel File Export from SPSS

[Morrell, Ronald]

Every month I need to prepare password protected Excel spreadsheets from a SPSS data set.  Currently, I’m using an Excel macro to do this.  I would like to do it through the SAVE TRANSLATE command, since it works much quicker.  I’ve been researching online to see if I can password protect these spreadsheets using the SAVE TRANSLATE command.  I know the help documentation does not show that functionality.  I am hoping that someone has figured out how to do this with the SAVE TRANSLATE command.

 

Thanks in advance for any advice.

 

Have a Great Day!

 

Ronald A. Morrell

GOCII, Office of Research and Planning

PH: [phone]

 

If life were any better, I’d be a twin.

 

You know what, I AM!

 

Learn more about DJJ’s Roadmap to System Excellence at http://www.djj.state.fl.us/roadmap-to-system-excellence

 

 

 

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Rick Oliver-3]

As far as I know, you cannot create a password-protected Excel file with Save Translate.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]



From:        "Morrell, Ronald" <[hidden email]>
To:        [hidden email]
Date:        07/08/2014 01:53 PM
Subject:        Password Protecting an Excel File Export from SPSS
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Every month I need to prepare password protected Excel spreadsheets from a SPSS data set.  Currently, I’m using an Excel macro to do this.  I would like to do it through the SAVE TRANSLATE command, since it works much quicker.  I’ve been researching online to see if I can password protect these spreadsheets using the SAVE TRANSLATE command.  I know the help documentation does not show that functionality.  I am hoping that someone has figured out how to do this with the SAVE TRANSLATE command.
 
Thanks in advance for any advice.
 
Have a Great Day!
 
Ronald A. Morrell
GOCII, Office of Research and Planning
PH: [phone]
 
If life were any better, I’d be a twin.
 
You know what, I AM!
 
Learn more about DJJ’s Roadmap to System Excellence at http://www.djj.state.fl.us/roadmap-to-system-excellence
 
 
 

===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@... (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Morrell, Ronald]

Thanks for the response, I was hoping I could.  Seems like it would be a nice feature for SPSS.

 

Ron

 

From: Rick Oliver [mailto:[hidden email]]
Sent: Tuesday, July 08, 2014 3:16 PM
To: Morrell, Ronald
Cc: [hidden email]
Subject: Re: Password Protecting an Excel File Export from SPSS

 

As far as I know, you cannot create a password-protected Excel file with Save Translate.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]



From:        "Morrell, Ronald" <[hidden email]>
To:        [hidden email]
Date:        07/08/2014 01:53 PM
Subject:        Password Protecting an Excel File Export from SPSS
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Every month I need to prepare password protected Excel spreadsheets from a SPSS data set.  Currently, I’m using an Excel macro to do this.  I would like to do it through the SAVE TRANSLATE command, since it works much quicker.  I’ve been researching online to see if I can password protect these spreadsheets using the SAVE TRANSLATE command.  I know the help documentation does not show that functionality.  I am hoping that someone has figured out how to do this with the SAVE TRANSLATE command.
 
Thanks in advance for any advice.
 
Have a Great Day!
 
Ronald A. Morrell
GOCII, Office of Research and Planning
PH: [phone]
 
If life were any better, I’d be a twin.
 
You know what, I AM!
 
Learn more about DJJ’s Roadmap to System Excellence at http://www.djj.state.fl.us/roadmap-to-system-excellence
 
 
 

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD