Automated RMG Quote Generator
Budget: ₹1,500 – ₹12,500 INR
I need a single master Word document that, with the help of VBA, can turn into a finished quotation for a Rapid Mixer Granulator the moment I pick the required options. The template must live entirely in Word; every block of technical text, every photo or diagram, and every commercial figure has to appear (or stay hidden) automatically once the macro knows which variant I have selected.
Key points I must achieve
• One master file that holds all possible specification blocks for items such as basic machine (standard / hygienic), seal type, and another half-dozen configurable features.
• A user-friendly form (I’m open to the controls you recommend—dropdowns, radio buttons, check-boxes, or a mix) to capture the choices.
• Dynamic assembly of the technical specification section, including images, captions, and consistent numbering.
• A commercial summary table that pulls unit prices for only the chosen options, shows subtotals and an overall total, and then locks the figures.
• Automatic naming and saving of the finished quote into a “Generated Quotes” folder.
What I need from you
1. The Word template, structured with bookmarks, content controls, Quick Parts or any building-block method you feel is most robust.
2. Well-commented VBA that drives the option form, inserts the correct content, updates the price table, and triggers the save routine.
3. A separate, easily editable repository (could be a hidden Word table or linked Excel sheet) that holds each option’s description, image path, and price so I can update figures without touching the code.
4. A brief how-to guide so I can add new options later.
If you’ve done similar configurator or quote-builder work in Word VBA, especially where images are involved, that experience will be invaluable. Let me know your approach and how quickly you can have a first working draft ready.
Key points I must achieve
• One master file that holds all possible specification blocks for items such as basic machine (standard / hygienic), seal type, and another half-dozen configurable features.
• A user-friendly form (I’m open to the controls you recommend—dropdowns, radio buttons, check-boxes, or a mix) to capture the choices.
• Dynamic assembly of the technical specification section, including images, captions, and consistent numbering.
• A commercial summary table that pulls unit prices for only the chosen options, shows subtotals and an overall total, and then locks the figures.
• Automatic naming and saving of the finished quote into a “Generated Quotes” folder.
What I need from you
1. The Word template, structured with bookmarks, content controls, Quick Parts or any building-block method you feel is most robust.
2. Well-commented VBA that drives the option form, inserts the correct content, updates the price table, and triggers the save routine.
3. A separate, easily editable repository (could be a hidden Word table or linked Excel sheet) that holds each option’s description, image path, and price so I can update figures without touching the code.
4. A brief how-to guide so I can add new options later.
If you’ve done similar configurator or quote-builder work in Word VBA, especially where images are involved, that experience will be invaluable. Let me know your approach and how quickly you can have a first working draft ready.