Excel link fields
Excel link fields
Excel Link fields link Tedds for Word and Excel together, so that your Excel calculations can be sent to Tedds for Word, or the other way around. To create Excel Link fields and create a Tedds compatible Excel worksheet, follow the instructions below.
The following only applies to Tedds for Word.
Create Excel Link fields
- In the Insert ribbon group, click Tedds field.
The Insert Tedds field dialog box appears, displaying the Input tab.
- Click the Excel tab.
The following view appears.
- Specify the details of the field.
- In the Filename field, full path and filename of the Excel document to which you want to link.
- In the Link Sheet field, type the name of the linking worksheet in the Excel document you set above. Note:
An Excel file may have several worksheets involved in the calculations, but there can only be one worksheet that you use as the link between Tedds for Word and Excel. The selected worksheet receives the variables from Tedds for Word and contains the resultant variables to return to Tedds for Word.
The linking worksheet must conform to a particular layout. You can find a worksheet with this layout in ProgramData\Tekla\Structural\Tedds\Excel\TEDDS2XL.xls. You can use the file by copying the path into the Link Sheet field, or create and use your own worksheet.
- In the Output Picture list, select whether you want to return a chart or a picture of selected table cells from Excel to Tedds for Word.
- If you do not want to include a picture, select None.
- If you want to include a picture of a chart, select Chart.
After that, type the name of the sheet and, if there are more than one charts in the sheet, the chart name.
- If you want to include a picture of a selected range of cells, select Table Range.
After that, type the name of the sheet and the range of cells which you want to include from the selected sheet.
- In the Options list, adjust the link options according to your needs.
- If you want to transfer variables from Tedds for Word to Excel, select Link variables from Tedds to Excel.
- If you want to transfer variables from Excel to Tedds for Word, select Link variables from Excel to Tedds. Note:If you check both of the link options above, then the order in which the data is transferred is:
- From Tedds for Word to Excel
- From Excel back to Tedds for Word.
If you wish to transfer data in the reverse order, create two Excel Link fields. In the first link, only select the Link variables from Excel to Tedds option. In the second link, only select the Link variables from Excel to Tedds option.
- If you want to have Excel open when the calculations are performed, select Show Excel.
- If you select the Show Excel option, you can also select Wait for workbook to be closed before linking in finished. If you select the Wait for workbook to be closed before linking in finished option, the linking process will pause until you close the Excel worksheet.
- If you want to save the workbook after performing the calculations, select Save workbook when linking is finished.
- If necessary, you can make Excel run up to three macros during the linking process. Select the macros in the Excel macros to run whilst linking section.
- If you want to run a macro before the variables are passed to Excel from Tedds for Word, type its name in the leftmost field.
- If you want to run a macro after the variables have been passed but before they are returned to Tedds for Word, type its name in the middle field.
- If you want to run a macro after performing the linking, type its name in the rightmost field.
- Click OK.
Create a compatible Excel worksheet
You can find a compatible Excel worksheet on your computer in ProgramData\Tekla\Structural\Tedds\Excel\TEDDS2XL.xls. You can use the file by copying the path into the Link Sheet field, or create and use your own worksheet. To create your own worksheet, see the following instructions.
- In your Excel worksheet, create two sets of three columns. Leave one empty column between the sets.
- In the central cell above the first three columns, type the title Variables from Tedds.
- In the central cell above the second three columns, type the title Variables back to Tedds.
- In the cells below the titles, type the following subtitles:
The following image illustrates how the worksheet should look.Note:
Although you can do calculations within the Variables back to Tedds cells, we do not recommend this.You do not need to fill in any values in either of the Value columns. Tedds for Word automatically enters values to the Value cells during the calculation.