Journal of the Korea Institute of Information and Communication Engineering (한국정보통신학회논문지)

The Korea Institute of Information and Commucation Engineering (한국정보통신학회)
권호 표지
DOI QR코드

DOI QR Code

Design of Application Module for the Excel File Security Management

엑셀 파일의 보안 관리를 위한 응용 프로그램 모듈 설계

  • Jang, Seung Ju (Department of Computer Engineering, Dongeui University)
  • Received : 2019.06.10
  • Accepted : 2019.07.06
  • Published : 2019.09.30
Download PDF
⟨ Previous Next ⟩

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.

본 논문은 엑셀 VBA 패스워드가 설정된 파일에 대한 수정 모듈을 설계한다. 엑셀 VBA 파일에 패스워드를 설정 후 패스워드를 잃어버린 경우 소스 코드 변경 등이 불가능하게 된다. 본 논문은 이러한 사용자들을 위해서 편리하게 VBA 파일 패스워드를 수정할 수 있도록 한다. VBA패스워드 수정 모듈은 엑셀 파일내의 VBA 파일을 추출한다. VBA프로그램 파일에서 특정 필드 정보의 수정을 통해서 패스워드를 수정할 수 있도록 한다. 이렇게 하여 VBA프로그램 파일에 대한 패스워드를 수정할 수 있도록 한다. 본 논문에서 제안한 내용을 구현하여 실험을 수행하였다. 실험을 수행한 결과 정상적으로 동작됨을 확인할 수 있었다.

Keywords

References

  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. Excel Off The Grid, VBA Code to Password Protect an Excel file, [Internet]. Available : https://exceloffthegrid.com/vba-code-password-protect-excel-file/.
  8. 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. https://doi.org/10.1111/j.0000-0000.2012.01044.x
  9. 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. https://doi.org/10.9723/jksiis.2016.21.2.093
  10. 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. https://doi.org/10.24018/ejers.2018.3.6.769
  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. https://doi.org/10.6109/jkiice.2014.18.1.217
  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. https://doi.org/10.14257/jse.2014.12.08