How to call VBA/c# code from office js without using API

Question

There are few limitation in offcie js Excel such as reading or adding notes into the cell.

I want to use VBA in these cases. How can I trigger the event or run the VBA code from office js Excel

If there is any way I can invoke ribbon commands(defined in xlam file) from office js , that would also be appreciated

Answer 1

I can imagine a workaround that works as follows:

• The office-js add-in adds a row to a table on a (hidden) worksheet with all details for the Note: Sheet, Cell address, Comment text
• The VBA add-in has an application-level event handler that responds to changes made to that worksheet.
• If a change is detected, the VBA add-in reads the table and inserts the notes appropriately, then empties the table.