Export HarnWare to Zuken E3

By Mark Harris

Excel macro to export multiple HarnWare Harness Manufacturing Drawings to a Zuken E3 project. Press: Ctrl+I to run the macro which will open Visio. Browse to the drawing(s) and highlight the Visio file(s) and select open. Each file will open in Visio temporarily and then close. At the end of this, the Zuken E3 excel…

HarnWare Harness Metrics

By Mark Harris

Excel macro to generate metrics for multiple HarnWare harness drawings. Table output has the following columns: File Path, Mass (kg), Reliability (fpmh), Labour (hrs)

HarnWare Template

By Mark Harris

Macro enabled Visio template file for HarnWare harness designs. Press: Ctrl+Q to run the macro which will: populate the reliability table transfer total mass to the harness drawing strike through old “S” and “T” RoHS codes add Standard Operating Procedures to CoP fit every page to window

Export HarnWare to Windchill

By Mark Harris

Excel macro to export your HarnWare Bill of Materials (BoM) to PTC Windchill for multiple harness designs. Press: Ctrl+I to run the macro which will open Visio. Browse to the drawing(s) that you wish to import the BOM for. Highlight the Visio file(s) and select open. Each file will open in Visio temporarily and then…