Browse > Article
http://dx.doi.org/10.6109/jkiice.2019.23.9.1173

Design of Application Module for the Excel File Security Management  

Jang, Seung Ju (Department of Computer Engineering, Dongeui University)
Publication Information
Journal of the Korea Institute of Information and Communication Engineering / v.23, no.9, 2019 , pp. 1173-1178 More about this Journal
Abstract
In this paper, we design a security management application module for an Excel VBA password file. You will set a password for the important VBA program file. If this password is lost, you set a new password. If you forgot the password after setting the password in the Excel VBA file, you will not be able to change the VBA source code. In this paper, we design a function to modify VBA file passwords conveniently. The VBA password modification module extracts VBA files from Excel files. The password can be modified by modifying specific field information in the extracted VBA program file. This allows you to modify the password for the VBA program file. The experiments were performed by implementing the contents proposed in this paper. As a result of the experiment, we can confirm that the password can be used by modifying the VBA file password.
Keywords
VBA; VBA Password; VBA Password Changing; Module; Design;
Citations & Related Records
Times Cited By KSCI : 2  (Citation Analysis)
연도 인용수 순위
1 R. Swadley, Excel VBA Programming For Dummies, 2nd ed. John Willey & Sons, Inc. 2018.
2 T. A. Grossman, "Source Code Protection for Applications Written in Microsoft Excel and Google Spreadsheet," [Internet]. Available: https://www.researchgate.net/publication.
3 J. Paine, "Documenting Spreadsheets with Pseudo-Code: an Exercise with Cash-Flow and Loans," [Internet]. Available: https://arxiv.org/abs/0908.1187.
4 B. Y, Yu, "How to check the properties of VBA objects (Centered on Chart-Sheet object Series, ChartGroup members," The Journal of Korean Business Research, vol. 2, no. 1, pp. 29-53, Jun. 2018.
5 T. E. Kang, N. J. Lee, and Y. R. Kim, "Control Module for the HEC-RAS by the Visual Basic for Applications in Excel," in Proceddings of KOREAN SOCIETY OF CIVIL ENGINEERS, Busan, pp. 394-395, Oct. 2017.
6 David E. Clough, Improve Your Spreadsheet Productivity with VBA, [Internet]. Available : https://www.aiche.org/resources/publications/cep/2017/june/improve-your-spreadsheet-productivity-vba.
7 S. J. Jang, "DESIGN OF THE FILE SEPARATION STRUCTURE FOR EXCEL VBA PROGRAM," European Journal of Engineering and Technology, vol. 3, no. 6, pp. 39-45, Jun. 2018.   DOI
8 Excel Off The Grid, VBA Code to Password Protect an Excel file, [Internet]. Available : https://exceloffthegrid.com/vba-code-password-protect-excel-file/.
9 M. R. Bartolacci, L. J. LeBlanc, Y. Kayikci, and T. A. Grossman, "Optimization Modeling for Logistics: Options and Implementations," Journal of Business Logistics, vol. 33, no. 2, pp. 118-127, Jun. 2012.   DOI
10 Y. R. Kim, T. G. Kang, and E. B. Lee, "SAP R/3 System Interface Technologies Analysis and VBA Applied Data Input Proposal," Journal of the Korea Industrial Information Systems Research, vol. 21, no. 2, pp. 93-105, Apr. 2016.   DOI
11 Z. Zhang, "Construction of the Multimedia Teaching Platform of Cost Accounting Course Based on EXCEL VBA Program," International Journal of Emerging Technologies in Learning (iJET), vol. 13, no. 5, 2018.
12 S. J. Jang, and D. H. Ryu, "Design of Efficient Data Search Function using the Excel VBA DAO ," Journal of the Korea Institute of Information and Communication Engineering, vol. 18, no. 1, pp. 217-222, 2012.   DOI
13 J. H. Ju, S. Y. Ma, and J. S Moon, "Proposal of Security Requirements for Storage Virtualization System against Cloud Computing Security Threats," Journal of Security Engineering, vol. 11, no. 6, pp. 469-478, 2014.   DOI