Free Excel VBA Tool

Free AutoCAD 3D Weld Neck Flange Generator

Select NPS, pressure class, pipe schedule and RF or RTJ facing in Excel. Version 1.3 lets you prepare one flange or select multiple flange configurations and generate a separate AutoCAD .scr file for each of them in one batch.

Multiple flange configurations. One batch. Ready-to-run AutoCAD scripts.

No account required. Downloads as a macro-enabled Excel workbook (.xlsm).

Free to download No account required Version 1.3 SHA-256 published

Conceptual and educational modelling only. Independently verify every dimension and generated model before use.

Version 1.3 demonstration

See the complete workflow

Watch the Version 1.3 workflow: select the flange parameters in Excel, generate the .scr file, run it in AutoCAD and review the conceptual 3D solid.

This updated demonstration shows VoxelStudio Flange Generator 1.3 in action. Playback is optional; the workflow is also explained in text below.

VoxelStudio Flange Generator 1.3 demonstration with multiple generated flange variants.

How it works

From one or many Excel selections to AutoCAD 3D models

  1. 1

    Select one or many flange configurations

    Choose the required NPS, pressure class, pipe schedule and RF or RTJ facing combinations.

  2. 2

    Generate the script set

    The Excel VBA workbook checks every selected configuration and creates a separate .scr file for each flange.

  3. 3

    Run the required scripts

    Open each script in AutoCAD and place the corresponding flange at the required insertion point.

  4. 4

    Review the generated 3D solids

    Inspect every conceptual model and independently verify all dimensions before any engineering use.

Capabilities

What the tool does

  • Generates conceptual weld-neck flange geometry.
  • Uses NPS, pressure class, pipe schedule and RF/RTJ facing selections.
  • Lets you select one flange configuration or multiple configurations in the same workbook.
  • Creates a separate AutoCAD .scr file for every selected flange in one batch.
  • Supports an interactive insertion point in AutoCAD.
  • Includes internal checks for data completeness and consistency.
  • Provides a practical example of Excel-to-AutoCAD automation.

Requirements

What you need

  • Microsoft Excel for Windows with VBA macros enabled.
  • A compatible desktop version of AutoCAD capable of running .scr scripts and 3D solid commands.
  • Permission under your organisation's IT and macro-security policies.

Compatibility note: AutoCAD LT compatibility has not been verified and is not claimed.

Verified release details

Download information

Free direct download. No registration or email verification is required.

Download Free Excel Tool
File
VoxelStudio_Flange_Generator_v1_3.xlsm
Version
1.3
Type
Microsoft Excel Macro-Enabled Workbook (.xlsm)
Size
392,511 bytes (383.31 KiB)
Published
Last updated
SHA-256
632A741BC7D2FD90762F37C3FEF25EEAD85CDED393465F86878C59397B50FD62

Safe start

Before enabling macros

  1. Download the workbook only from the official VoxelStudio product page.
  2. Compare its SHA-256 with the value above. In Windows PowerShell, run Get-FileHash "path-to-file.xlsm" -Algorithm SHA256.
  3. Review the downloaded file and follow your organisation's IT and macro-security policy.
  4. Enable VBA macros only when permitted and only after verifying the file.
  5. Review the generated .scr commands and resulting geometry before use.

Engineering disclaimer

Important engineering limitations

This free tool is intended for conceptual and educational 3D modelling only. It is not ASME-certified, endorsed by ASME, or a substitute for current licensed standards. It must not be used for design, fabrication, procurement, inspection, certification or safety-critical decisions. All dimensions, materials, ratings and generated geometry must be independently verified by a qualified professional against the applicable licensed standards and project requirements.

The workbook uses nominal dimensional references associated with ASME B16.5 and ASME B36.10, supported during development by publicly available reference data from Wermac and Van Leeuwen. Mentioning these sources does not imply certification or endorsement.

Detailed guide

See the Excel-to-AutoCAD workflow step by step

Read how flange configurations are checked, converted into separate AutoCAD scripts and used to create conceptual 3D solids.

Read the complete workflow

FAQ

Frequently asked questions

Is the VoxelStudio Flange Generator free?

Yes. Version 1.3 is available as a free direct download without account registration.

What does the tool generate?

It generates a separate AutoCAD .scr file for each selected weld-neck flange configuration. You can process a single flange or a batch of configurations.

Which parameters can I select?

NPS, pressure class, pipe schedule and RF or RTJ facing.

Does it generate a certified ASME model?

No. The output is conceptual and educational only. All dimensions and geometry must be independently verified.

Does it work without AutoCAD?

Excel can generate the script, but a compatible AutoCAD installation is required to create and view the 3D model.

Why is the file an .xlsm workbook?

The workbook uses Excel VBA to validate selections and generate the AutoCAD script.

Is registration required?

No. The download is direct. An optional email subscription is offered only after the download starts.

Does it work with AutoCAD LT?

AutoCAD LT compatibility has not been verified and is not claimed.

Questions or practical feedback: [email protected]