Browse > Article
http://dx.doi.org/10.6109/jkiice.2014.18.1.217

Design of Efficient Data Search Function using the Excel VBA DAO  

Jang, Seung Ju (Department of Computer Engineering, Dongeui University)
Ryu, Dae-Hyun (Department of Computer IT, Hansei University)
Publication Information
Journal of the Korea Institute of Information and Communication Engineering / v.18, no.1, 2014 , pp. 217-222 More about this Journal
Abstract
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.
Keywords
Data Search Algorithm; Excel Data Search; Excel; DAO; Visual Basic for Application(VBA);
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 Park, Hae won, "Program Development and Distribution Analysis Using Excel VBA", Seoul Nat'l Univ. M.S Theses, 2011.
2 Park, Jun Wong , "Logistics Regression Analysis Program Using Excel VBA", Seoul Nat'l Univ. M.S Theses, 2012.
3 Lee, Ahn Na, "Sample Extraction Program Using Excel VBA", Seoul Nat'l Univ. M.S Theses, 2013.
4 Kim, Sung Min, "Log Linear Regression Analysis Using Exce VBA", Seoul Nat'l Univ. M.S Theses, 2013.
5 Choi Hyun Seok, Park Chul Yong, "Implementation Education Tool of the Variable Regression Model Using Excel VBA", Korea Data Information Journal, 24(3) pp.593- 601, 2013.   DOI   ScienceOn
6 Choi Hyun Seok, Ha Chung Cheol, "Implementation Statistics Education Tool of the Procedural Base Using Excel Macro", Korea Data Information Journal, Vol. 22 No 4, pp.643-650, 2011. 7.
7 Choi Jun Sun, Excel Macro VBA Bible, HanBit Media, 2012.6.
8 John Walkenbach, Excel 2007 Power Programming With VBA, Predeck, 2010.11.
9 Lee Chong Seok, Excel 2010 Macro & VBA, Digital Media Books, 2012.3.
10 Lee Gang Jae, 200 Excel Functions for Field Workings, Sejin Books, 2011.2.
11 Richard Mansfield, Mastering VBA for Office 2010, SYBEX, 2010. 8.
12 Ko Eung Nam, Visual Basic Programming, HanBit Media,, 2007. 10.
13 Kim Eun Jung, Advanced Excel & VBA Programming for Expert, E-Han Media, 2012. 2.