• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.23 no.9
• /
• pp.1173-1178
• /
• 2019

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.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.18 no.1
• /
• pp.217-222
• /
• 2014

In this paper, I propose an efficient data search system using data partitioning algorithm in Microsoft Excel. I propose searching algorithm to retrieve data quickly using VBA functioning in the Excel. This algorithm is to specify the sheet you are looking for. Once the sheet is specified, the algorithm searches the beginning and the end of the data in the sheet. The algorithm compares intermediate values and key words, from the starting position of the cell. In this way, it will search data to the end. This proposed algorithm was implemented and tested in the Excel system using VBA program. The experimental results showed that the performance was better than that of the conventional sequential search method.

• Journal of the Korea Safety Management & Science
• /
• v.14 no.2
• /
• pp.167-176
• /
• 2012

This research studies the present status of utilization of IT in SMB, Small & Medium Business, logistics companies, and analyzes the examples of utilizing Excel VBA for building and operating IT system in SMB logistics companies. Through the study, this research suggests main issues of building and operating logistic systems and the effective way of utilizing the systems in SMB logistics companies.

• Proceedings of the Safety Management and Science Conference
• /
• 2011.11a
• /
• pp.181-189
• /
• 2011

This research studies the present status of utilization of IT in SMB, Small & Medium Business, logistics companies, and analyzes the examples of utilizing Excel VBA for building and operating IT system in SMB logistics companies. Through this study, this research suggests main issues of building and operating logistic systems and the effective way of utilizing the systems in SMB logistics companies.

• The magazine of the Korean Society for Advanced Composite Structures
• /
• v.6 no.2
• /
• pp.57-67
• /
• 2015

• Journal of the Korean Data and Information Science Society
• /
• v.24 no.3
• /
• pp.593-601
• /
• 2013

We often need to include categorial variables as explanatory variables in regression models. The categorial variables in regression models can be quantified through dummy variables. In this study, we provide an education tool using Excel VBA for displaying regression lines along with test results for regression models with a continuous explanatory variable and one or two categorical explanatory variables. The regression lines with test results are provided step by step for the model(s) with interaction(s), the model(s) without interaction(s) but with dummy variables, and the model without dummy variable(s). With this tool, we can easily understand the meaning of dummy variables and interaction effect through graphics and further decide which model is more suited to the data on hand.

• Transactions of the KSME C: Technology and Education
• /
• v.2 no.1
• /
• pp.21-28
• /
• 2014

As one of the most famous spreadsheet programs that is widely applied to a variety of fields in business, MS Excel has also been used for educational purposes due to its feature of wide accessibility, enabling students to use the program through almost any kind of PC that now exists. The program is mainly used for numerical analysis and formulae applications in the fields of science and engineering. This paper shall provide the key to understanding the application of MS Excel to teaching Statics through the illustration of its essential functions for education. Also, the development process of the analysis program using macros and VBA(Visual Basic for Applications) is described for the deeper comprehension of advanced applications. Students were not only able to solve the Statics problems using basic features of MS Excel, but also discovered new systematic methods of approaching complex problems and developed application programs using macros and VBA.

• Korean Journal of Agricultural and Forest Meteorology
• /
• v.20 no.2
• /
• pp.228-232
• /
• 2018

Process-based crop models have been used to assess the impact of climate change on crop production. These models are implemented in procedural or object oriented computer programming languages including FORTRAN, C++, Delphi, Java, which have a stiff learning curve. The requirement for a high level of computer programming is one of barriers for efforts to develop and improve crop models based on biophysical process. In this study, we attempted to develop a Chinese cabbage model using Microsoft Excel with Visual Basic for Application (VBA), which would be easy enough for most agricultural scientists to develop a simple model for crop growth simulation. Results from Soil-Plant-Atmosphere-Research (SPAR) experiments under six temperature conditions were used to determine parameters of the Chinese cabbage model. During a plant growing season in SPAR chambers, numbers of leaves, leaf areas, growth rate of plants were measured six times. Leaf photosynthesis was also measured using LI-6400 Potable Photosynthesis System. Farquhar, von Caemmerer, and Berry (FvCB) model was used to simulate a leaf-level photosynthesis process. A sun/shade model was used to scale up to canopy-level photosynthesis. An Excel add-in, which is a small VBA program to assist crop modeling, was used to implement a Chinese cabbage model under the environment of Excel organizing all of equations into a single set of crop model. The model was able to simulate hourly changes in photosynthesis, growth rate, and other physiological variables using meteorological input data. Estimates and measurements of dry weight obtained from six SPAR chambers were linearly related ($R^2=0.985$). This result indicated that the Excel/VBA can be widely used for many crop scientists to develop crop models.

• 한국정보통신설비학회:학술대회논문집
• /
• 2009.08a
• /
• pp.36-39
• /
• 2009

We developed an optimal design interface based on VBA(Visual Basic Application) that takes advantage of API(Application Program Interface) function of commonly used EM analysis software. The developed interface is adopted for an optimal design of a septum in a waveguide tee junction using PSO(Particle Swarm Optimization) algorithm. The objective function of the optimal design is defined by $S_{11}$-parameter of the waveguide tee junction Design variables are established as position of the septum, that are changed to satisfy the design goal Using the developed design interface and PSO algorithm, the objective function converged to the smallest value, showing the validity of the proposed method. The design interface was developed using Microsoft Excel software, enabling easy control of design parameters for user. Also, various analysis parameters can be set in the Excel interface, including waveguide input mode and frequency. After completion of the design, field solutions at user-specified positrons can be extracted to the output files in complex number form.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.35 no.2
• /
• pp.16-20
• /
• 2012

The purpose of this thesis is to develop a performance rating training tool for the time and motion study. It is widely recognized that rating training tools based on films were made several decades ago and introduced to Korea. However, to the best of our knowledge, those films are not used for rating training in Korea any more. Furthermore, although rating is still important method for the efficient operational management study, it is briefly mentioned without any training or exercise. In this paper, we propose a simple rating training tool based on Excel with VBA. The mottoes of our development are the ease of acquisition and trainees' motivation. Test results show that trainees can obtain the concept of rating and the ability of accurate and consistent rating as they play a computer game sitting in front of the personal computer.