title: How to make Win32::OLE work on 64bit MS OFFICE installation
body: <p>I have two PCs, one has MS Office 2013 32bit installed and another MS Office 64bit installed.
  I have Perl code that is using <a href="https://metacpan.org/pod/Win32::OLE" rel="noreferrer"><code>Win32::OLE</code></a> Perl module to manipulate XLS spreadsheets.
  The code is working perfectly fine on 32bit PC, but has a problem on 64bit one.</p>
  
  <p>After doing some research here is what I found out.
  The problem is the following line of code:</p>
  
  <pre><code>use Win32::OLE::Const 'Microsoft Excel .* Object Library';
  </code></pre>
  
  <p>I looked inside <a href="https://metacpan.org/pod/Win32::OLE::Const" rel="noreferrer"><code>Win32::OLE::Const</code></a> module and it seems that the module is looking for that library in the registry. When I printed out all entries from the registry from both 32 and 64 bit I found out that this library is available on 32bit and not available on 64bit.</p>
  
  <p>Is there a way to install that library on 64 bit? If not, are there any other modules that would allow OLE automation of Excel?</p>
  
  <p>All my Perl script needs to do is to open XLS file and save it as CSV. I am doing it with <a href="https://metacpan.org/pod/Spreadsheet::ParseExcel" rel="noreferrer"><code>Spreadsheet::ParseExcel</code></a> and <a href="https://metacpan.org/pod/Spreadsheet::XLSX" rel="noreferrer"><code>Spreadsheet::XLSX</code></a> in all other scripts. The problem with this particular XLS file is that it is password protected and using non-standard password encryption. So <code>Spreadsheet::ParseExcel</code> is not able to open it. <code>Win32::OLE</code> has no issues opening the file on 32bit.</p>
  
  <p>Code can be provided if needed.</p>
  
  <p>Please advise.</p>
  
  <p>Thank you,
  -Andrey</p>