BookmarkSubscribeRSS Feed
Rajkumar2
Calcite | Level 5
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.
1 REPLY 1
ChrisNZ
Tourmaline | Level 20

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

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 1 reply
  • 1482 views
  • 0 likes
  • 2 in conversation