Category: Excel

Excel Macros

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

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 …

Export HarnWare to Windchill Read More »

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

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