How to import password protected excel files by using sas eg

[Rajkumar2]

Hello guys.,
I'm trying to import data from password protected excel files by using sas eg.
I'm trying with dde method but it showing some errors. Is there any other way to import it.

[ChrisNZ]

I am pretty sure the only way would be to write a vbs script inspired by this one or this one.

This requires Excel on the server though, which is uncommon, for obvious reasons