Is it possible to call an Excel add-in from VBA in Word in reasonably simple way?

Question

I have an add-in that helps fill Excel tables with data from Atlassian Jira, used by several kinds of Excel files. The add-in has been created with the Excel VBA editor, not VSTO. Now I need to use the functions of this add-in from macros in a Word template. To avoid duplicating the code base, I would like to use this add-in in Word. Trying to add a reference to the Excel add-in in Word triggers the error "Can't add a reference to the specified file". Is there a reasonably simple way to achieve this?

Answer 1

If you want the best next thing you can do is inserting Excel table into Word document and then adding to that document your VBA code.

To add the Excel tabel just use Insert -> Table -> Excel Spreadsheet -> your toolbar will change to excel toolbar with the option for adding your VBA code like in Excel.