Category: Excel

Excel Macros

HarnWare Harness Metrics

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

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

Microsoft Project to Excel

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

Folder Sizes

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