ISSN: 2222-6990
Open access
The metrology industry is heading towards digitalization and automation. Calibration reports provided by the metrology organizations are frequently used to establish compliance with the quality management system and legal obligations. Each calibration report requires manual approval, which is often time consuming and inefficient. This study focuses on developing a certificate approval system for a metrology organization using VBA. The new system will be developed using Visual Basic for Application in Excel and deployed into a metrology organization. The data will be extracted from the organization system, and a survey will be conducted after the implementation. This research uses the waterfall model which is a software development process that is carried out sequentially. The findings of this study indicate that the system has successfully integrated with the organization’s process and has shown a significant impact on the time required to complete and approve a calibration report. According to the survey, users believe that it is easier and faster, accessible, adaptable, and overall, it complements the requirements needed by the organization. The practical use of these results can assist the company in increasing its productivity and efficiency in providing calibration reports hence, adding competitive value to its brand.
Abdulaziz, Q. A., Mad Kaidi, H., Masrom, M., Hamzah, H. S., Sarip, S., Dziyauddin, R. A., & Muhammad-Sukki, F. (2023). Developing an IoT framework for Industry 4.0 in Malaysian SMEs: An analysis of current status, practices, and challenges. Applied Sciences, 13(6), 3658. https://doi.org/10.3390/app13063658
Abu Bakar, M. R., Mat Razali, N. A., Ishak, K. K., Ismail, M. N., & Tengku Sembok, T. M. (2024). Adoption of Industry 4.0 with cloud computing as a mediator: Evaluation using TOE framework for SMEs. JOIV: International Journal on Informatics Visualization, 8(2), 554. https://doi.org/10.62527/joiv.8.2.2205
Balakrishnan, B., Othman, Z., & Zaidi, M. F. A. (2021). Review of IR4.0 readiness and adoption in Malaysian manufacturing sector. International Journal of Business and Economy, 3(2), Article 2.
Boyar, K., Pham, A., Swantek, S., Ward, G., & Herman, G. (2021). Laboratory information management systems (LIMS). In S. R. Opie (Ed.), Cannabis Laboratory Fundamentals (pp. 131–151). Springer. https://doi.org/10.1007/978-3-030-62716-4_7
Creswell, J. W., & Creswell, J. D. (2018). Research design: Qualitative, quantitative, and mixed methods approaches (5th ed.). SAGE.
Hund, A., Wagner, H.-T., Beimborn, D., & Weitzel, T. (2022). Organizational identity in the digital era. Proceedings of the Annual Hawaii International Conference on System Sciences. https://doi.org/10.24251/hicss.2022.846
International Standard ISO/IEC 17025: General requirements for the competence of testing and calibration laboratories. (2017). Standards Malaysia.
International Vocabulary of Metrology. (2012). https://doi.org/10.59161/JCGM200-2012
Jaish, A. A., Murdipi, R., Razak, D. A., & Alwi, N. M. (2023). The effect of digitalization on the sustainability of Malaysian SMEs. International Journal of Academic Research in Business and Social Sciences, 13(1), 655–668.
Kadir, R. (2012). Malaysian DSA 1997: A review of some unresolved issues. Asian Social Science, 8(12), 221.
Khan, M. A., Kalwar, M. A., Malik, A. J., Malik, T. S., & Chaudhry, A. K. (2021). Automation of supplier price evaluation report in MS Excel by using Visual Basic for Applications: A case of footwear industry. International Journal of Science and Engineering Investigations, 10(113), 49–60.
Khomariah, E. (2020). Turnover intention PT. Efrata Retailindo ditinjau dari beban kerja, lingkungan kerja dan kepuasan kerja. Business Management Analysis Journal, 3(1), 35–45. https://doi.org/10.24176/bmaj.v3i1.4429
Miguel, A. L. R., Moreira, R. P. L., & Oliveira, A. F. de. (2021). ISO/IEC 17025: History and introduction of concepts. Química Nova, 44(6), 792–796.
Newell, D. B., & Tiesinga, E. (2019). The international system of units (SI): 2019 edition. National Institute of Standards and Technology. https://doi.org/10.6028/nist.sp.330-2019
Ngoc, A. M., Nishiuchi, H., & Nhu, N. T. (2023). Determinants of carriers’ intentions to use electric cargo vehicles in last-mile delivery by extending the technology acceptance model: A case study of Vietnam. The International Journal of Logistics Management, 34(1), 210–235. https://doi.org/10.1108/IJLM-12-2021-0566
North, K., Aramburu, N., & Lorenzo, O. J. (2019). Promoting digitally enabled growth in SMEs: A framework proposal. Journal of Enterprise Information Management, 33(1), 238–262. https://doi.org/10.1108/jeim-04-2019-0103
Nurjaman, A., Juandi, D., Supriyadi, E., Hidayat, W., & Darhim, D. (2024). Research trends about Visual Basic as a programming language in the learning process: A bibliometric analysis. International Journal of Electrical and Computer Engineering, 14(6), 6498. https://doi.org/10.11591/ijece.v14i6.pp6498-6507
Paramarta, N. A., & Setiyowati, N. (2024). The role of job stress as mediator on the relationship between job demands on PT X outsourced driver turnover intention. Jurnal Sains Psikologi, 13(1), 55–63. https://doi.org/10.17977/um023v13i12024p55-63
Pargaonkar, S. (2023). A comprehensive research analysis of software development life cycle (SDLC) agile & waterfall model advantages, disadvantages, and application suitability in software quality engineering. International Journal of Scientific and Research Publications, 13(8), 120–124.
Perzylo, A., Rickert, M., Kahl, B., Somani, N., Lehmann, C., Kuss, A., Profanter, S., Beck, A. B., Haage, M., Rath Hansen, M., Nibe, M. T., Roa, M. A., Sornmo, O., Gestegard Robertz, S., Thomas, U., Veiga, G., Topp, E. A., Kessler, I., & Danzer, M. (2019). SMErobotics: Smart robots for flexible manufacturing. IEEE Robotics & Automation Magazine, 26(1), 78–90. https://doi.org/10.1109/mra.2018.2879747
Prasad, P. J., & Bodhe, G. L. (2012). Trends in laboratory information management system. Chemometrics and Intelligent Laboratory Systems, 118, 187–192.
Program Studi D-III Akuntansi … & Yasmin, A. (2024). The design of an accounting information system based on VBA macros in Microsoft Excel. International Journal of Innovative Research in Multidisciplinary Education, 3(3). https://doi.org/10.58806/ijirme.2024.v3i3n22
Raharjo, K. (2019). The role of green management in creating sustainability performance on small and medium enterprises. Management of Environmental Quality, 30(3), 557–577. https://doi.org/10.1108/meq-03-2018-0053
Snieška, V., Navickas, V., Havierniková, K., Okr?glicka, M., & Gajda, W. (2020). Technical, information and innovation risks of Industry 4.0 in small and medium-sized enterprises: Case of Slovakia and Poland. Journal of Business Economics and Management, 21(5), 1269–1284. https://doi.org/10.3846/jbem.2020.12279
Tham, K. W., & Yaakub, S. A. A. @. (2021). SME readiness towards digitalization in Malaysia. Research in Management of Technology and Business, 2(1), Article 1.
Van Tonder, C., Hasanefendic, S., Bossink, B., Schachtebeck, C., & Nieuwenhuizen, C. (2023). Internal organizational factors driving digital transformation for business model innovation in SMEs. Journal of Business Models, 11(2). https://doi.org/10.54337/jbm.v11i2.7403
Wang, Y., Gu, J., Wang, S., & Wang, J. (2019). Understanding consumers’ willingness to use ride-sharing services: The roles of perceived value and perceived risk. Transportation Research Part C, 105, 504–519. https://doi.org/10.1016/j.trc.2019.05.044
Wang, Z. (2023). Digital transformation and risk management for SMEs: A systematic review on available evidence. Advances in Economics, Management and Political Sciences, 65(1), 209–218. https://doi.org/10.54254/2754-1169/65/20231639
Wong, H. S., & Muhamad, M. M. (2022). Electronic signature and attestation in conveyancing practice: A Malaysian legal perspective. F1000Research, 11, 325.
Zhu, Y., & Liu, J. (2019). Design and implementation of intelligent measurement testing and calibration management information system based on big data. Journal of Physics: Conference Series, 1237(4), 042038.
Hui, D. L. C., Daud, P., & Nadi, F. (2025). Improving the Calibration Certificate Approval Process for Metrology Industry in Accordance with ISO 17025 by Using VBA. International Journal of Academic Research in Business and Social Sciences, 15(12), 312–325.
Copyright: © 2025 The Author(s)
Published by HRMARS (www.hrmars.com)
This article is published under the Creative Commons Attribution (CC BY 4.0) license. Anyone may reproduce, distribute, translate and create derivative works of this article (for both commercial and non-commercial purposes), subject to full attribution to the original publication and authors. The full terms of this license may be seen at: http://creativecommons.org/licences/by/4.0/legalcode