ITERATIONS in calling programs from EXCEL
ITERATIONS in calling programs from EXCEL
(OP)
who knows how to use an excel macro to launch an analysis program?
i have to perform a parametric structural analysis, and i intend to create an excel sheet whith all the parameters data, with a macro that activates the structural program at each iteration and also copies the output at each step
thanks
i have to perform a parametric structural analysis, and i intend to create an excel sheet whith all the parameters data, with a macro that activates the structural program at each iteration and also copies the output at each step
thanks





RE: ITERATIONS in calling programs from EXCEL
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: ITERATIONS in calling programs from EXCEL
Dim TextLine
Open "TESTFILE" For Input As #1 ' Open file.
Do While Not EOF(1) ' Loop until end of file.
Line Input #1, TextLine ' Read line into variable.
'analyze Textline using string functions to find the data you need
Loop
Close #1 ' Close file.
yakov
RE: ITERATIONS in calling programs from EXCEL
RE: ITERATIONS in calling programs from EXCEL
Shell("C:\program files\gtstrudl\gtstrudl.exe inputfile.dat -l outputfile.out")
You need to contact SAP2000 support for syntax and for the key to access the database. Good luck!
RE: ITERATIONS in calling programs from EXCEL