Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

System and method for automatically generating BOM by using VBA function

A technology of automatic generation and function, applied in the direction of geometric CAD, etc., to achieve the effect of reducing development and improving customization depth

Pending Publication Date: 2020-11-24
SICHUAN JIULI MICROWAVE
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention provides a system and method for automatically generating BOM using VBA functions. The technical problem to be solved is to provide an economical and flexible method on the basis of compatibility with deeply customized file templates, so as to facilitate the production without manual intervention. Automatically generate BOM from assembly drawings to meet efficient and accurate requirements

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • System and method for automatically generating BOM by using VBA function
  • System and method for automatically generating BOM by using VBA function
  • System and method for automatically generating BOM by using VBA function

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0067] Take AutoCAD as an example of application software;

[0068] Such as figure 1 and image 3 Shown, a kind of system that uses VBA function to generate BOM automatically, comprises: graphic-text storage system, it is used to store the text information corresponding to assembly drawing and assembly drawing; Graphic-text processing system, it is installed with VBA module, and establishes VBA project, the VBA module uses VB language to write programs, and the VBA module is used to classify, organize and generate BOM for the component information in the assembly drawing, and the VBA project provides a working environment for the VBA module, and uses the CAD VBA function to automatically generate BOM Methods.

[0069] Before using this method, you should ensure that the AutoCAD assembly drawing template contains the necessary content, and the specific form can be deeply customized according to the standardization requirements:

[0070] First, define the frame and title temp...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for automatically generating a BOM by using a CAD VBA function, and relates to the field of computer aided design. The method is characterized in that the method comprises the steps that S1, an AutoCAD assembly pattern template is prepared, which comprises a drawing frame and a drawing question template of an assembly drawing and a drawing frame and a drawing question template of a BOM; S2, a VBA module is installed in AutoCAD software, and a VBA project is established; and S3, a VBA program is written into the VBA project, and the VBA program is compiled in aVB language and used for processing an assembly pattern file. The method overcomes the defects as follows: an existing manual operation mode is large in operation amount and prone to making mistakes,and the associated implementation workload in the product engineering change process is large; the existing development software needs to use a specified database, so that the software purchase cost and the enterprise operation cost are high; although an automatic BOM can use a custom template, but the custom depth is insufficient, and the standardization requirement is difficult to meet.

Description

technical field [0001] The invention relates to the field of computer-aided design, in particular to a system and method for automatically generating a BOM by using a VBA function. Background technique [0002] In addition to drawing parts and components, the current drawing software is often used to draw assembly drawings, which are used to explain the assembly relationship of each part and its specification and model requirements. After the design and development personnel complete the drawing of the assembly drawing, they often need to sort out the associated parts and components information (code, model, quantity, etc.) in the drawing to form the assembly details (referred to as BOM) as the basis for the implementation of supporting materials. [0003] According to the traditional background technology, BOM sorting is mainly completed by manual operation of drafting personnel, or automatically sorted by individual design and development software, and there are obvious de...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F30/12
CPCG06F30/12
Inventor 卢国良包明
Owner SICHUAN JIULI MICROWAVE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com