Linking STAAD.Pro with Excel using OpenSTAAD

OpenSTAAD is a very powerful tool to link STAAD.Pro engine with any other third party software. This session focuses on how to link STAAD.Pro with Excel using the OpenSTAAD function. This session will cover:
An introduction to OpenSTAAD and learn how to find the right function.
How to create a macro-enabled Excel file using OpenSTAAD.
How to execute the Excel VBA macro to link with STAAD.Pro and exchange data.
The Excel file created in this session can be found here: communities.be...
Session 1 on this topic can be found here: • Introduction to OpenSTAAD
For more information on STAAD, please visit www.bentley.co...
To earn professional learning units online, be sure to check out our:
· Live Webinars: pages.info.bent...
· OnDemand Webinars: pages.info.bent...
· Courses on LEARNserver: learn.bentley.c...
Follow us!
· LinkedIn: / analytical-modeling
· Facebook: / bentleysystems
Twitter: / bentleysystems

[@brettwyman2984]

Why is the documentation syntax for VBA different than the syntax you use?
Example:
Dim nNodeNo As VARIANT = OSGeometryUI.AddNode(fCoordX, fCoordY, fCoordZ)
vs
Dim Node as long
Node = obj.Geometry.AddNode(x,y,z)
I've tested both. The former doesn't work but the latter does. Why is the documentation wrong?

[@sachindeshmukh3228]

Thank you for sharing such great quality knowledge💐☺️

[@AT-wx2bw]

Found a way to Reference the Library. Not Sure if old but working.
My Suggestion is Start with How to Reference Library and make Intellisense work on it.
In Short:
Always a Great Idea to find out first, if in VBA editor OPEN STAAD Library of functions is available? If not How to add a reference both Manually or at a runtime.
Once Referenced -How to make Iintelisense work correctly on OpenStaad Library of functions.

[@saedhalteh1286]

Thanks for such great session, really informative.

[@AsifAli-uu4wq]

Is there any python Libraries available for staad.pro to replace VBA?

[@Augusto5191]

hi, im making macros like this but openstaad seem to be extremely slow.... do you know how to overcome this problem?

[@NodesAutomations]

Hello Augusto, there are multiple way to solve this problem but that depends on your task. you can use C# or Directly run macro inside staad vba editor.

[@jitendraparate6360]

Dear sir That was a very nice session. I tried to develop an application to automate 3d structure with supports and load assignments. As I am individually assigning loads to the members many loads of same value are appearing in one load case. I want to create a group and assign a load to the members in this group. But I am not able to create group using OS.geometry.creategroup(2 ,"_ROOFBEAMS") command.
Can you guide me with a sample code to create group of members. And apply loads to the members in the grouo
But I could not get the proper syntax format for

[@shehab976]

Where is the open staad documentation for c#

[@ganesh9971]

Is any code to activate copy picture command and paste that picture in excel

[@NodesAutomations]

No