Home Forums Developer forum Excel API

Tagged: , ,

Viewing 1 post (of 1 total)
  • Author
  • #3766
    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.

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.