Papers by Keyword: VBA

Abstract: Urban traffic expert developed many methods to judge the performance of urban road to provide driving instruction to both drivers and the local authority. In Beijing, the traffic performance index is widely used by people every day. In order to store the traffic performance index data which is continually changed to local database, our team has tried many different ways to achieve it because we want to do deep analyze of it. By using VBA programming we successfully build a data extract system to store data. We use two different ways to process the data from the system based on data missing type. At last, the data is ready for further study to find the traffic pattern of urban area.

Abstract: In this paper, combined with trainees ' locking mistakenly or doing wrong with work order that others initiated and problems that teaching schedule and teaching quality is unable to control ,we use “Macro Program” and “Microsoft ODBC for Oracle” to develop the training auxiliary tools in the EXCEL' s circumstances by VBA programming technology and then we achieved the goal of the teaching results of closed-loop test and operation of information broadcast which is based on the working process.

Abstract: The vertical profiles along the coast are indispensable to research in coastal dynamic and Marine-topography evolution, but there is no perfect method to make them in rapid and batched way. This paper presents a feasible process to make it, there, Golden software surfer11.0 generates grid files by its scripter program, and then the files are called in VBA of EXCEL2003 to plotting the profiles. The process runs effectively in the physical model for the nourishment project of beach in Beidaihe New Area, it also makes a promotion in the report writing and data analysis. The result shows that the method is practicable.

Abstract: By using the technology of CAD drawing and standard design calculation is very necessary and feasible. Designers can use the technology of parametric drawing, carries on two times of CAD development of the use of VBA language, the water processing graphics processing and engineering graphics rendering and completed in the computer, realize the parametric design of water treatment structures. Users only need to input the basic parameters that can be completed treatment structure graphics and rendering in CAD, reduce the processing procedure and time complexity. Based on the traditional plug flow aeration tank as an example, introduces the parametric design of traditional plug flow aeration tank by VBA.

Abstract: Die-set is an essential tool accessory in sheet metal punching and blanking. The selection of the die-set represents an important activity in the die design operation. Time and money consumed in this operation could be saved by using an automated selection system for die-set components. This paper discusses an intelligent die-set selection system using the AutoCAD platform. The developed system is able to work as either standalone or connected with any die design CAD system by using the well-known AutoCAD programming tools. The proposed system is built using IF-THEN rules approach. The system code is developed using AutoCAD with Visual Basic. A data-base of Nasr Automotive Company (NASCO) for die-set was considered, from which suitable size of die-set was selected automatically. The proposed system could reduce the consumed time in the tool room department from hours to minutes and could reduce effort and cost as well.

Abstract: This paper proposed an automatic transformation technical solution for behavior control scripting languages. The solution automatically converts VBA scripting language into JavaScript scripting language. It implements automatic transformation by analyzing and comparing differences in the use of different grammatical of VBA scripts and JavaScript scripts such as data types, control structures, form controls and add-ins Etc. To ensure the accuracy and completeness of conversion the solution generates an abstract syntax tree which represents call and transitive relation between functions. Compared with the conversion tools the solution can reduce repeated manpower and improve productivity.

Abstract: This paper proposes an information hiding method based on word text, according to the theory of the human eye cones for the color sensitivity; the human eye is least sensitive to blue. I change the lowest two bits of G component in the carrier text character RGB color value, change the lowest two bits of R component in the carrier text character RGB color value, and change the lowest four bits of B component in the carrier text character RGB color value, So that each carrier text character can hide 8 bits binary information. RGB color value of character underline can hide 24 bits information; the combination of these two methods can hide 32 bits binary information. After testing, the results show that the algorithm hiding rate is high, the algorithm is stable and easy to implement, has a certain application value.

Abstract: Nowadays, the computer is increasingly popular, and college examination is developing in the direction of traditional examination means to automation and intelligence ones gradually, all these make it inevitable to construct question bank for courses, and to generate test paper using computers. This paper uses the Delphi technique, to make improvements to existing components, combining with VBA programming, and use of SQL Server to implement the question bank management and test paper auto-generation system, which could generate test paper in Word Document. A large number of tests show that the software is running stably and system features are functioning correctly on Windows 2000/XP/2003 platform with Office XP/2003 environment.

Abstract: Drawing charts are odd work by adding a data source manually and setting other parameters such as border, legend etc in Excel. The key technologies and implementation methods of chart-automatic-drawing are described using embedded VBA Programming codes.

Abstract: Test reports given by test institution are mostly stylized text. Editing such text is a hard and odd work. A method is introduced to implement report automatically creating based on VBA and Words template technology, such as bookmark, ChartObject etc. The method used in our engine performance test-bed laboratory works well and reduces report editing time form half a day to half an hour.