Excel AddIn Documentation

Pascal Vuong

Hi Boardies

We are currently trying to solve it with the use of VBA since no native solution came to our minds and we want to automatize it as much as possible.

The problem is following:

A single table (lets say, country, year, period (BoP, A, EoP)) grouped by countries on one screen. From the Excel sheet the table should be split by countries, the rest stays the same and on each of these split tables, a different "Board Layout Selection" can happen. All tables are on 1 single sheet and not like the standard, 1 per worksheet, so the sheet Selection is also not an option.

Unfortunately, I didn't find any useful documentation on how to use the AddIn, as I also cannot use the SetSelect, etc. functions on the cells itself.

Following Error occurs to me:
"Unable to cast COM object of type 'System.__ComObject' to interface type 'BoardAddInUtils.IAddinUtilities'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{8E5C56BF-D9BC-4E29-97EA-648D4E532444}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))."

Any help, ideas and suggestions are much appreciated.

Best,

Pascal

Kayne Schwarz

@Pascal Vuong,

As you may have already discovered, we have Excel Add-In documentation on the Board Manual available here:

https://www.boardmanual.com/2021/summer/whats-new-release-notes/spring-2021-release/Main_features/Excel_add-in.htm?rhsearch=Excel&rhhlterm=excel

I'll follow up with you further offline, thanks!

Zachary Turner

There is an Excel Add-in VBA video on Board Education in the course "Board 10 Product Tutorial." It is on Board 10, but it should still apply here. It requires registered to access the section called: "The MS Excel Add-in - How - Add in Formulas and Vb Script"
https://edu.board.com/board-10-product-tutorial/15437

Vikash Gupta

Hi Pascal,

I stumbled upon this post in our Board community when searching for any solutions for the COM Component related error while working with Excel Add-in. One of our partner consultant is facing a similar issue and not able to find a solution for the same. Just wanted to check if you have been able to solve this issue at your end and if so what was the solution?

Regards,

Vikash