OS. Additional References
Documentation for VBA is beyond the scope of this manual and Bentley does not provide direct support on how to write VBA macros. There are, however, several useful and free sites on the Web to assist a beginner on writing macros in STAAD, Excel, AutoCAD, or any other VBA compliant software.
It should be noted that the VBA language is the same from software to software. However, the functions, objects, and core libraries will obviously vary.
The sites recommended by Bentley are as follows:
-
https://msdn.microsoft.com/en-us/vba/ (refer to the
Office VBA Object library reference
to get started) - https://stackoverflow.com
- https://www.oreilly.com/
- http://www.wrox.com
Also, it is worth noting that many programs such as MicroStation and Microsoft Office Excel have a useful Record Macro feature. You can run the recorder and then select any commands from the program's ribbon tabs. The corresponding VBA syntax will automatically be generated.