A Case of VBA Application in Transaction Processing

DOI

10.2991/msmee-17.2017.311How to use a DOI?

Keywords

VBA, Transaction Processing, Excel, Word, Mapping Table, Efficiency

Abstract

Plenty of transactional work is continual, odd and time-consuming. Using the VBA technique can simplify the work procedure and liberate the workforce. A case of fetching required information from Word files and filling into the sheet of an Excel file is discussed. A general method of using embedded VBA codes and a mapping table is proved to be efficient, easy to implement and meet the demand.

Copyright

© 2017, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Guoliang Dong
AU  - Guofang Wu
AU  - Chaozhou Chen
PY  - 2017/05
DA  - 2017/05
TI  - A Case of VBA Application in Transaction Processing
BT  - Proceedings of the 2017 2nd International Conference on Materials Science, Machinery and Energy Engineering (MSMEE 2017)
PB  - Atlantis Press
SP  - 1717
EP  - 1720
SN  - 2352-5401
UR  - https://doi.org/10.2991/msmee-17.2017.311
DO  - 10.2991/msmee-17.2017.311
ID  - Dong2017/05
ER  -