title: Exporting Microsoft Office 16.0 Office Library and use it with Excel 2013
body: <p>I used Excel 2016 to create an Excel table with VBA program to generate a Word Document report automatically. The macro generates a compile error when used on Excel 2013 with older Office Library.</p>
  
  <p>I tried the following without success:</p>
  
  <ul>
  <li>using an older version of Excel to save the macro (no improvement).</li>
  <li>changing the code (e.g: Word.Application -> Object) as proposed on other threads. The main problem is that the program is ~2000 lines long and when I fix something, another compile error arise a few lines later. Plus, the formatting in the Word document is altered.</li>
  <li>updating to Office 2016 is not a solution either for various compatibility reasons with other programs.</li>
  </ul>
  
  <p>The only remaining solution I can see is to export the Microsoft Office 16.0 Office Library and the Microsoft Excel 16.0 Library to the computers running Excel 2013 and adding them to the VBA References.</p>
  
  <p>I cannot locate these 2 Libraries. The path is shown in the Tools->References window but is cut because the window is too short (and of course not possible to resize).</p>
  
  <p>What is the path and file name to the 2 libraries? </p>
  
  <p>Do you think that this solution will work and if not, do you know a better one or a workaround?</p>