VBA integration with BOARD Using the Excel Add-in
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
Accepted Answer
-
correct,
this is currently a limitation of the addin.
Regards
Björn
1
Answers
-
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
0 -
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
Pierre0 -
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
1 -
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 ?0
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP