How to change the default location for Excel Design result file?

Tekla Structures
Not version-specific
Tekla Structures
excel design
excel result
excel
Environment
Not environment-specific
Question:
How can a user control the output folder for Excel design sheets? By default it is created in model folder. Can it be changed to some other folder, for example to C:\results\ ?

Answer:
You can change the default location for .xls result file. it is defined in excel.vb file in line 537:

Dim resultname = modelDir + "\" + CStr(getJointStructVariable("id")) + "_res.xls"

You can change that to e.g:

Dim resultname = “C:\results\” + CStr(getJointStructVariable("id")) + "_res.xls"

There is also the "ExcelDesignResults” folder which gets created in model folder and contains results in html format. Its location is hardcoded and cannot be changed.
Was this helpful?