https://communities.sas.com/t5/SAS-Programming/How-to-import-multiple-password-protected-excels/m-p/664692#M198618 <P>I have a folder of password protected xlsx files. They all have one sheet, have the same data columns with clean data, but the specific names of each excel&nbsp;varies since these are manually saved. Is it possible to write a code to&nbsp;import all of the files in the folder and&nbsp;compile into one SAS&nbsp;dataset? They are all password protected with the same password. I have several folders like this that I would like to apply this to, and they&nbsp;are added to&nbsp;every week so having a more automated process would be greatly helpful.</P><P>&nbsp;</P><P>I've looked at some online&nbsp;articles regarding importing multiple unprotected files, and importing one password protected file, but I haven't been able to find a way to import all the password protected excel files in the folder. My understanding of SAS macros is still fairly beginner. I am using SAS 9.4 TS Level 1.3</P><P>&nbsp;</P><P>Thank you for your help!</P> Wed, 24 Jun 2020 16:20:25 GMT MFSas 2020-06-24T16:20:25Z https://communities.sas.com/t5/SAS-Programming/How-to-import-multiple-password-protected-excels/m-p/664692#M198618 <P>I have a folder of password protected xlsx files. They all have one sheet, have the same data columns with clean data, but the specific names of each excel&nbsp;varies since these are manually saved. Is it possible to write a code to&nbsp;import all of the files in the folder and&nbsp;compile into one SAS&nbsp;dataset? They are all password protected with the same password. I have several folders like this that I would like to apply this to, and they&nbsp;are added to&nbsp;every week so having a more automated process would be greatly helpful.</P><P>&nbsp;</P><P>I've looked at some online&nbsp;articles regarding importing multiple unprotected files, and importing one password protected file, but I haven't been able to find a way to import all the password protected excel files in the folder. My understanding of SAS macros is still fairly beginner. I am using SAS 9.4 TS Level 1.3</P><P>&nbsp;</P><P>Thank you for your help!</P> Wed, 24 Jun 2020 16:20:25 GMT https://communities.sas.com/t5/SAS-Programming/How-to-import-multiple-password-protected-excels/m-p/664692#M198618 MFSas 2020-06-24T16:20:25Z https://communities.sas.com/t5/SAS-Programming/How-to-import-multiple-password-protected-excels/m-p/664974#M198739 <P>It could not be I think, You need remove these password by hand or vbs before importing .</P> Thu, 25 Jun 2020 12:01:34 GMT https://communities.sas.com/t5/SAS-Programming/How-to-import-multiple-password-protected-excels/m-p/664974#M198739 Ksharp 2020-06-25T12:01:34Z