topic Re: How to import password protected excel files by using sas eg in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/How-to-import-password-protected-excel-files-by-using-sas-eg/m-p/464937#M2238 <P>I am pretty sure the only way would be to write a vbs script&nbsp;inspired by this <A href="https://communities.sas.com/t5/SAS-Procedures/Import-a-password-protected-Excel-doc/m-p/33890#M8213" target="_self">one</A> or this <A href="https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-import-password-protected-excel-files-in-SAS-Enterprise/m-p/278169#M19231" target="_self">one</A>.</P> <P>This requires Excel on the server though, which is uncommon, for obvious reasons</P> <P>&nbsp;</P> Fri, 25 May 2018 03:51:41 GMT ChrisNZ 2018-05-25T03:51:41Z How to import password protected excel files by using sas eg https://communities.sas.com/t5/Microsoft-Integration-with-SAS/How-to-import-password-protected-excel-files-by-using-sas-eg/m-p/464796#M2237 Hello guys.,<BR />I'm trying to import data from password protected excel files by using sas eg.<BR />I'm trying with dde method but it showing some errors. Is there any other way to import it. Thu, 24 May 2018 15:03:27 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/How-to-import-password-protected-excel-files-by-using-sas-eg/m-p/464796#M2237 Rajkumar2 2018-05-24T15:03:27Z Re: How to import password protected excel files by using sas eg https://communities.sas.com/t5/Microsoft-Integration-with-SAS/How-to-import-password-protected-excel-files-by-using-sas-eg/m-p/464937#M2238 <P>I am pretty sure the only way would be to write a vbs script&nbsp;inspired by this <A href="https://communities.sas.com/t5/SAS-Procedures/Import-a-password-protected-Excel-doc/m-p/33890#M8213" target="_self">one</A> or this <A href="https://communities.sas.com/t5/SAS-Enterprise-Guide/Can-we-import-password-protected-excel-files-in-SAS-Enterprise/m-p/278169#M19231" target="_self">one</A>.</P> <P>This requires Excel on the server though, which is uncommon, for obvious reasons</P> <P>&nbsp;</P> Fri, 25 May 2018 03:51:41 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/How-to-import-password-protected-excel-files-by-using-sas-eg/m-p/464937#M2238 ChrisNZ 2018-05-25T03:51:41Z