• 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.

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

• 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.

• 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.

• 한국정보통신설비학회:학술대회논문집
• /
• 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.

• Analytical Science and Technology
• /
• v.9 no.1
• /
• pp.84-90
• /
• 1996

New hepatocyte specific copolymers, that have oligosaccharide and biotin residue on the side chain of styrene, were designed and synthesized to use as a multifunctional recognition. In order to measure initial adhesion efficiency, 1mL of copolymer solutions (0.01%, w/v) such as p(VLA-co-VBA) 90 : 10, p(VLA-co-VBA) 80 : 10 and PYLA as a standard were added to polystyrene petri dish, respectively. In the absence and presence of serum, hepatocyte solution of rat by method of Seglen was added. After 60 min, adhesion efficiency was 70%, that is similar to those of the absence of serum. Aggregation capacity between biotin residue in p(VLA-co-VBA) 70 : 30 and avidin was measured by using UV-transmittance.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 2002.10a
• /
• pp.195-202
• /
• 2002

Generally, bridge designers must consider variable factors in design of bridge-structures. For this reason, it was difficult to make a design program till now. However, the rapid development of computers turns it into a possible one with considering complex factors and the advance of computer's language make us design programming. When we use the automatic design program including structural analysis(FEM), we can save the time and effort. Additionally, the automatic design program was generated to reduce the man' errors. Therefore, in this paper, the automatic design program of the Prestressed Concrete Slab Bridge was developed. This design program will support bridge designers with time that they can spend on a creative and efficient duty for development of design.

• 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.