Design of Efficient Data Search Function using the Excel VBA DAO
엑셀 VBA DAO 기능을 이용한 효율적인 데이타 검색 기능 설계

Seung Ju Jang, Dae-Hyun Ryu
2014 The Journal of the Korean Institute of Information and Communication Engineering  
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
more » ... 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. 키워드 : 데이터 검색 알고리즘, 엑셀 데이터 검색, 엑셀, DAO, VBA
doi:10.6109/jkiice.2014.18.1.217 fatcat:cq66g7m32vg6xh72sn7vc5h2k4