VBA integration with BOARD Using the Excel Add-in

Pierre L. · 2024-04-05T15:34:25+00:00

There was an error rendering this rich post.

Hello,
I'm trying tu use VBA to automate a connection with the BOARD tab in Excel.

I found a manual with macro code sample, but it doesn't work in my case…

Sub DoConnect()
Dim addin As Office.comaddin
Dim automationObject As Object
Set addin = Application.COMAddIns("BoardExcelAddIn")
Set automationObject = addin.Object
If automationObject.Connect("https://gps.laposte.fr/", 9700, Nothing, Nothing, False, True) Then
MsgBox "Connected"
Else
MsgBox "Not Connected"
End If
End Sub

I get an "insufficient memory" pop-up…

I'm Connecting with SSO, but if I use the script :

If automationObject.Connect("https://gps.laposte.fr/", 9700, False, True)

I get an "incorrect procedure" pop-up…

Can you help me with this VBA script ?

Thank You ! :-)

Pierre

Find more posts tagged with

Add-In

Accepted answers

Björn Reuber

correct,

this is currently a limitation of the addin.

Regards

Björn

All comments

Björn Reuber

Hello Pierre,

first of all, your script is correct. But unfortunately it can't work in an Cloud environment.

Using the script the Addin is connecting DIRECTLY to the Board Engine using port 9700. This is not allowed in cloud instances, cause the login must be through the Subsciption Hub (which is not yet supported by the script).

I'll tag @Product Management Team that they have a look on this.

Regards

Björn

Pierre L.

Hello Björn,

Thank you for your quick answer.

I'm not sure to understand your explanation about "not working in an Cloud environnement" … ?
Board is always a "Cloud environnement" ?

And I'm using the Excel fat client (not Online Excel).
→ With VBA script, the "DisConnect" and "IsConnect" commands work fine for me.
→ When using the Add-In in Excel, the connection by clicking the "Connect" button, in the Board tab, works perfectly, using the same "Host" and 9700 "Base Port".

Why then is that the "Connect" VBA command could not work the same ? by simulating the click on the "Connect" button ?

Thank you
Pierre

Björn Reuber

Hello @Pierre L.

Board can be also used in an onPremise environment,.

I assume for the connect button you are using https://gps.laposte.fr as host adress, in this case the base port 9700 is not used and the Addin is using the Board Web API as an proxy server. So you are not directly connecting to board engine, you are connecting through our webAPI

regards

Björn

Pierre L.

Thank you.
OK.
… and the VBA script can not simulate the click on the "Connect" button, in the Board tab,
then connecting through the webAPI, through the https://gps.laposte.fr host address ?

Björn Reuber

correct,

this is currently a limitation of the addin.

Regards

Björn