Teaching Methodology for Microsoft Excel Workbook Creation Using the Excel Object Model (VBA)
Authors
Bashirova Goncha Imanverdi gizi
Share
Annotation
This article examines the object-oriented components of the Microsoft Excel Application Software System and provides foundational knowledge for establishing a programming interface between Visual Basic for Applications (VBA) and Excel. It is noteworthy that the Microsoft Excel Object Model (MEOM) displays certain differences from standard Object-Oriented Programming (OOP) paradigms. Programmers must consider these distinctions when developing application systems in the Excel and VBA environment. This study demonstrates how OOP mechanisms are implemented within MEOM and emphasizes its unique features. An Excel application file, referred to as a workbook, can be extensively manipulated through MEOM using VBA. The article introduces the primary components of MEOM that facilitate these operations and illustrates their application in practical procedures and functions.
Keywords
Authors
Bashirova Goncha Imanverdi gizi
Share
References:
Alexander, M., & Walkenbach, J. (2013). Excel dashboards and reports.
Chaudhry, A. K., Kalwar, M. A., Khan, M. A., & Shaikh, S. A. (2021). Improving the Efficiency of Small Management Information System by Using VBA. International Journal of Science and Engineering Investigations, 10(111), 7-13.
Ebere, F. O., Ekwueme, H., Onwuama, C. N., Adu-Mensah, D., Nkok, L., & Josephs, R. (2024). Advancing Reservoir Performance Optimization through User-Friendly Excel VBA Software Development. Petroleum & Petrochemical Engineering Journal, 8(1), 1-20.
Evensen, H. T. (2014, June). A versatile platform for programming and data acquisition: Excel and Visual Basic for Applications. In 2014 ASEE Annual Conference & Exposition (pp. 24-125).
Mertz, D. (2021). Cleaning data for effective data science. Packt Publishing.
Uwah, A., & Umoren, I. (2024). Soft Computing-Based System for Performance Modeling of Object-Oriented Programming (OOP) Software. European Journal of Computer Science and Information Technology, 12(2), 22-40.
Other articles of the issue
