title: Using libname statement in 64 bit SAS to interact with 32 Excel
body: <p>I have 64 bit SAS 9.4 installed and 32 bit Office 2007.  When I had 32 bit SAS 9.3 installed, I was able to use a libname statement where the Excel file was the library and the "filename" that follows after the period was in fact a worksheet or named range in the Excel file.  For example, you start with a libname statement</p>
  
  <pre><code>libname exceltst path="C:\Users\username\Documents\test.xlsx";
  </code></pre>
  
  <p>And, then later you can reference a named range in this with exceltst.stuff, assume "stuff" is a named range.</p>
  
  <p>So, is this still possible?  I am guessing it has to do with 64 bit sas and 32 bit excel but I am wondering if there is some variation that still works.  I am able to use a proc export to export to the excel file and it works just fine but I have tried 20 variations on the libname and can't get it to work.  The error I get is:</p>
  
  <pre><code>ERROR: Connect: Class not registered
  ERROR: Error in the LIBNAME statement.
  </code></pre>