OpenSees and VBA

[Toutant]

Dear all,

Is it possible to launch an OpenSees analysis using an Excel VBA script? I know it's possible with Matlab but I would prefer directly with a VBA script.

I created a spreadsheet to design CBF frames that executes SAP2000 analysis through a VBA script but I would like to add non-linear analysis with OpenSees.

Thanks.

[fmk]

if you can call SAP it means you can call any external program, so OpenSees should be able to be called as well.

[johnnyontheweb]

Sap has APIs for Vba.
Can the opensees apis be called from vba or .net?

[Toutant]

I was able to call OpenSees.exe from VBA but I couldn't send him commands e.g. source filename.tcl

What I ended up doing is making a VBA macro to execute a matlab script (.m file). In that script, I perform an OpenSees analysis using "!OpenSees.exe filename.tcl". Note that this matlab script can take input from Excel using xlsread command in matlab. Finally I extract results from Matlab back into my excel spreadsheet using Matlab API functions.

[johnnyontheweb]

There is not what I intended. An API allows you to call the function inside OS.