Excel has two different sorts of protection. The obvious one, Tools>Protection>Protect Sheet, lets you assign a password that prevents changing the sheet. However, it does not prevent anyone from reading or viewing the file. SPSS can still open this file.

There is another password mechanism, well hidden, that prevents anyone from viewing the sheet without the password. You apply this by doing a Save As and then click the Tools menu in the Save dialog box. There you can assign a password that has nothing to do with the other one. If you protect your document that way, SPSS cannot read it. SPSS is good -- but not that good :-)

Regards, Jon Peck

-----Original Message----- From: Straehle, Manfred [mailto:Manfred.Straehle@ghv.com] Sent: Friday, November 07, 2003 8:22 AM To: SPSSX-L@LISTSERV.UGA.EDU Subject: [SPSSX-L] Excel Security and SPSS

I just opened a protected excel workbook (requires password) in SPSS. Does anybody know why SPSS can open protected workbooks?

M.

-----Original Message----- From: Kraan, Egon [mailto:ekraan@BeechAcres.org] Sent: Friday, November 07, 2003 9:09 AM To: SPSSX-L@LISTSERV.UGA.EDU Subject: Re: get system datestamp

COMPUTE timesta = $time . FORMATS timesta (DATETIME20). EXECUTE .

-----Original Message----- From: Philip_Moore@CARMAX.COM [mailto:Philip_Moore@CARMAX.COM] Sent: Thursday, November 06, 2003 1:29 PM To: SPSSX-L@LISTSERV.UGA.EDU Subject: get system datestamp

I'm trying to automate a report that looks at data in a 12 and 3 month time window. Is there some way to "call" the current date from the PC's clock in syntax so that I can build the appropriate filters for the two time frames?

Thanks,

Philip Moore Market Research Manager (804) 747-0422 x4831 (804) 935-4549 FAX

The information in this email is extremely confidential. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. Please do not copy or disseminate any portion of this email.

****************************************************************** This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer. ******************************************************************