importing password protect excel file into sas

[Pavan_SAS]

importing password protect excel file into sas, how?

[Pavan_SAS]

i know the password also.

help me !

[sbb]

You may have success using the FILENAME and DDE engine, as is mentioned in the SUGI technical paper below; this document makes mention that the DDE "open function" accepts parameters, one that would be a password. The specific format is unfamiliar to me, and I could find no reference at the SAS support website http://support.sas.com/ .

You may want to open a SAS support track for this inquiry, if you cannot determine the correct approach on your own.

Scott Barry
SBBWorks, Inc.

http://www.sas-consultant.com/professional/SUGI26-Against-All-ODS-1.pdf


SAS 9.1 Companion for Windows - search for FILENAME and DDE engine:
http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/base_hostwin_6974.pdf