Excel Inventor Product Configurator Program

I need an Excel-driven product configurator that pushes parameters to Autodesk Inventor and automatically outputs the corresponding 3D model. The workbook will present a handful of predefined options—basic length, width, height and material selections—so the user can pick values from drop-downs, press a single button, and watch Inventor build the part or assembly in the background.

Scope
• Create a clean, password-protected Excel interface (xlsm) with clearly labelled input cells and validation lists for each option.
• Link those inputs to an Inventor template through VBA, iLogic, or Inventor’s API—whichever is most robust—so the model regenerates instantly and saves to a specified folder.
• Include error handling that alerts the user if an invalid combination is chosen or if Inventor is not running.
• Provide concise in-sheet instructions plus a short screen-recording that shows the configurator in action.

Acceptance criteria
1. Selecting any allowed option set produces a fully resolved Inventor part or assembly without manual edits.
2. Output filenames follow the pattern Part_[Option1]_[Option2].ipt (or .iam).
3. Workbook, macros and Inventor template are delivered in an organised folder ready for hand-off.