Date: Fri, 15 Jan 2010 13:48:05 -0500
Reply-To: Nathaniel Wooding <nathaniel.wooding@DOM.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Nathaniel Wooding <nathaniel.wooding@DOM.COM>
Subject: Problem in reading a password protected Excel File: Could not
Content-Type: text/plain; charset="us-ascii"
I just encountered this situation while trying to read a workbook created elsewhere. I can open the book using Excel and fill in data (it is a application created by an agency for use in reporting) but when I try to read the data that I have entered, I get the message "Could not decrypt File". SAS Support has a note
that dates to V8 but the issue still exists in 9.2. One workaround that they suggest is to use DDE so I throw this out for all those who question the continued use of DDE.
The issue is not a big deal for me and I have a work around or two planned. I should probably add that my interest in reading the fake data that I have entered is that there are some id codes created while the data are being entered and I want to capture these so that I can do the whole data entry process from within SAS rather than doing it manually screen by laborious screen.
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977
Cel Phone: 804-205-0752
CONFIDENTIALITY NOTICE: This electronic message contains
information which may be legally confidential and or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect. The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful. If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it. Thank you.