https://communities.sas.com/t5/SAS-Enterprise-Guide/Read-password-protected-excel-workbook-into-SAS/m-p/883396#M43260 Have a look at the solution offered in this paper: <A href="https://www.lexjansen.com/sesug/2018/SESUG2018_Paper-213_Final_PDF.pdf" target="_blank">https://www.lexjansen.com/sesug/2018/SESUG2018_Paper-213_Final_PDF.pdf</A> <BR />NOTE: The DDE method is described here: <A href="https://www.mwsug.org/proceedings/2013/FS/MWSUG-2013-FS04.pdf" target="_blank">https://www.mwsug.org/proceedings/2013/FS/MWSUG-2013-FS04.pdf</A> Tue, 04 Jul 2023 08:31:33 GMT JosvanderVelden 2023-07-04T08:31:33Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Read-password-protected-excel-workbook-into-SAS/m-p/883390#M43259 <P>Morning Folks,</P><P>&nbsp;</P><P>There is a master password protected excel workbook which I need to read the various sheets into SAS in order to lookup ID numbers. I need to do this on the fly and also ad-hoc as the workbook will be updated frequently. Is there a simple way to do this?</P><P>&nbsp;</P><P>Any help would be great.</P><P>&nbsp;</P><P>Sean&nbsp;</P> Tue, 04 Jul 2023 07:44:52 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Read-password-protected-excel-workbook-into-SAS/m-p/883390#M43259 Sean_OConnor 2023-07-04T07:44:52Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Read-password-protected-excel-workbook-into-SAS/m-p/883396#M43260 Have a look at the solution offered in this paper: <A href="https://www.lexjansen.com/sesug/2018/SESUG2018_Paper-213_Final_PDF.pdf" target="_blank">https://www.lexjansen.com/sesug/2018/SESUG2018_Paper-213_Final_PDF.pdf</A> <BR />NOTE: The DDE method is described here: <A href="https://www.mwsug.org/proceedings/2013/FS/MWSUG-2013-FS04.pdf" target="_blank">https://www.mwsug.org/proceedings/2013/FS/MWSUG-2013-FS04.pdf</A> Tue, 04 Jul 2023 08:31:33 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Read-password-protected-excel-workbook-into-SAS/m-p/883396#M43260 JosvanderVelden 2023-07-04T08:31:33Z