Does anybody have an idea how to start on a macro to add an equation in a BOM?
Recording a macro to do this gave no useful results.
From my experience:
A work around for using equations is manipulating individual cells of the BOM themselves.
The attached macro will look if there is a BOM inserted in the drawing.
If there is a BOM then it will look for a column named Plan (also in hidden columns and unhide if need be).
For each cell in this column it will enter the drawing file name and the BOM item number.
Cfr: File name=Test Name.slddrw
Then the values entered in the cells will be of format "Test Name-2"
In my case the column Plan is linked to the custom property Plan of the parts so when the cells are changed in the drawing then the part custom properties are also updated.
Hope this is useful to someone.
Retrieving data ...