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)

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…

Microsoft Project to Excel

By Mark Harris

Convert Microsoft Project Files (.mpp) to Excel (.xls) for sharing with collegues without a license. Requires one licensed copy of Microsoft Project.

Folder Sizes

By Mark Harris

VBA within Excel which creates a spreadsheet of all the folder / subfolder sizes.