https://communities.sas.com/t5/SAS-Programming/importing-password-protect-excel-file-into-sas/m-p/47535#M9838 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 <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> .<BR /> <BR /> You may want to open a SAS support track for this inquiry, if you cannot determine the correct approach on your own.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <A href="http://www.sas-consultant.com/professional/SUGI26-Against-All-ODS-1.pdf" target="_blank">http://www.sas-consultant.com/professional/SUGI26-Against-All-ODS-1.pdf</A><BR /> <BR /> <BR /> SAS 9.1 Companion for Windows - search for FILENAME and DDE engine:<BR /> <A href="http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/base_hostwin_6974.pdf" target="_blank">http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/base_hostwin_6974.pdf</A> Thu, 18 Sep 2008 14:34:44 GMT sbb 2008-09-18T14:34:44Z https://communities.sas.com/t5/SAS-Programming/importing-password-protect-excel-file-into-sas/m-p/47533#M9836 importing password protect excel file into sas, how? Thu, 18 Sep 2008 04:04:06 GMT https://communities.sas.com/t5/SAS-Programming/importing-password-protect-excel-file-into-sas/m-p/47533#M9836 Pavan_SAS 2008-09-18T04:04:06Z https://communities.sas.com/t5/SAS-Programming/importing-password-protect-excel-file-into-sas/m-p/47534#M9837 i know the password also.<BR /> <BR /> help me ! Thu, 18 Sep 2008 07:58:35 GMT https://communities.sas.com/t5/SAS-Programming/importing-password-protect-excel-file-into-sas/m-p/47534#M9837 Pavan_SAS 2008-09-18T07:58:35Z https://communities.sas.com/t5/SAS-Programming/importing-password-protect-excel-file-into-sas/m-p/47535#M9838 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 <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> .<BR /> <BR /> You may want to open a SAS support track for this inquiry, if you cannot determine the correct approach on your own.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <A href="http://www.sas-consultant.com/professional/SUGI26-Against-All-ODS-1.pdf" target="_blank">http://www.sas-consultant.com/professional/SUGI26-Against-All-ODS-1.pdf</A><BR /> <BR /> <BR /> SAS 9.1 Companion for Windows - search for FILENAME and DDE engine:<BR /> <A href="http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/base_hostwin_6974.pdf" target="_blank">http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/base_hostwin_6974.pdf</A> Thu, 18 Sep 2008 14:34:44 GMT https://communities.sas.com/t5/SAS-Programming/importing-password-protect-excel-file-into-sas/m-p/47535#M9838 sbb 2008-09-18T14:34:44Z