Study and Development on Report Automatic Creating System for Engine Performance Test-Bed Based on VBA

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.

• Periodical: Applied Mechanics and Materials (Volumes 427-429)
• Pages: 2373-2376
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.427-429.2373
• Online since: September 2013
• Authors: Guo Liang Dong*, Fu Jia Liu, Shu Quan Xu
• Keywords: Automotive Engineering, Dot, Engine Performance, Report Automatic Creating System, VBA

References

[1] Microsoft Corporation, Microsoft Excel Help[DB/OL].

[2] . Yunzhou Stiduo, Excel 2000 VBA[M], Posts & Telecom Press, (2000).

[3] Microsoft Corporation, Microsoft Excel 2000 Language Reference [M], Beijing Hope Electronic Press, (1999).

[4] Yao Wen-tao, Excel VBA Application Programming Instances[M] , Tsinghua University Press, (2009).

[5] Yunzhou Stiduo, Word 2000 VBA[M], Posts & Telecom Press, (2000).

[6] Microsoft Corporation, Microsoft Word Help[DB/OL].

[7] Wang Shun-xing, and Yan Mei-dai, Word 2000 VBA Tutorial and Instances Analysis[M] , Beijing University Press, (2001).

[8] Yang Rong-qing, and Zheng Zhi-gang, VBA Series Lessons , Computer Programming Skills & Intenance[J], 2001, pp.5-9.

[9] Douglas Hergert, Foundation of Visual Basic 4 For windows 95 Programming [M], IDG Book Worldwide inc., (1995).

[10] Mingri Tech., Gao Chun-yan, Liu bin-bin, and Wang Bin, Visual Basic Programming Bible[M] , Posts & Telecom Press, (2007).