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). If you have other versions of the Power Pivot add-in installed, those versions are also listed in the COM Add-ins list. Check the Microsoft Office Power Pivot box, and then click OK. In the Manage box, click COM Add-ins > Go. 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. Here’s how you enable Power Pivot before using it for the first time. updating to Office 2016 is not a solution either for various compatibility reasons with other programs.Plus, the formatting in the Word document is altered. The main problem is that the program is ~2000 lines long and when I fix something, another compile error arise a few lines later. changing the code (e.g: Word.Application -> Object) as proposed on other threads.The default folder location for the Excel Viewer on a 32-bit operating system isc:Program FilesMicrosoft OfficeOffice12. The file name of the Excel Viewer is xlview.exe. using an older version of Excel to save the macro (no improvement). The 32-bit version of the Excel Viewer can be used on 64-bit versions of Windows.The macro generates a compile error when used on Excel 2013 with older Office Library.
I used Excel 2016 to create an Excel table with VBA program to generate a Word Document report automatically.
0 kommentar(er)
