Read password protected excel workbook into SAS

[Sean_OConnor]

Morning Folks,

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?

Any help would be great.

Sean 

[JosvanderVelden · Accepted solution]

Have a look at the solution offered in this paper: https://www.lexjansen.com/sesug/2018/SESUG2018_Paper-213_Final_PDF.pdf
NOTE: The DDE method is described here: https://www.mwsug.org/proceedings/2013/FS/MWSUG-2013-FS04.pdf