Hello,
We use the EXCEL nomenclature extracted from SMARTBOOM via MyCadTools, I would like to know if it was possible to create a hyperlink that would allow to open the drawing according to the reference of each part, the drawings would be located in a folder on a server.
Thanks in advance
Hello;
Smartbom does not offer to create hyperlinks natively, but you can add a column with the full paths of the components in the BOM (smartbom), then in Excel (the model workbook used in Smartbom for this BOM) declare this column as " hyperlinks ".
Then if you have some knowledge of macro (VBA), you can link the names of your components to their respective addresses and hide the column with the full paths...
No need for a Macro: if the columns [component name] and [full path] are intended to retrieve information, the model workbook can provide an additional column with the formula = LIEN_HYPERTEXTE(full path; component name)
Not sure that this will work for me Smartbom will overwrite the formula with imported text, unless you provide a link column and another additional hyperlink (which smartbom does not fill) with the formula transmitted and which retrieves the value (link location) in the link (text) column.