Hi everyone, I'm trying to move my team away from using DDE to populate excel reports to using libname. Most of our code uses rsubmit and that works fine, but when I try to get to do the same thing without rsubmit I get an error. IE, this works: rsubmit; libname xl xlsx '\filepath\filename.xlsx'; data xl.exampledataset1; set exampledataset1; run; endrsubmit; This does not: libname xl xlsx '\filepath\filename.xlsx'; data xl.exampledataset1; set servwork.exampledataset1; run; It throws this error: ERROR: The XLSX engine cannot be found. ERROR: Error in the LIBNAME statement. Browsing suggests it's something to do with 64bit SAS vs 32bit Excel, but I would have thought our server was running the same version of SAS, Not sure how to confirm that though. Thanks, James
... View more