Excel API

[NextFEM Admin]

A template for Excel API can be downloaded here.

All the API functions can be called from VBA code, and they can become available to worksheets by simply encapsulating each call in a UDF function, like the following one:

Function NFgetBeamForce(num As Integer, loadcase As String, tp As Integer, station As Integer) As Double
‘ STATION: a beam has 5 stations (1, 2, 3, 4 or 5)
‘ TP: 1=N, 2=Vy, 3=Vz, 4=Mt, 5=My, 6=Mz
NFgetBeamForce = NF.getBeamForce(num, loadcase, “1”, tp, station)
End Function

This function can be called by any cell and any sheet in the workbook.

[Author]

Posts