User-form That Will Enable A Search Against A Massive Spreadsheet Being Used As A Database
Posted on 2013-01-22
Greetings Everyone. I am reaching out for some help on a project that I hope will teach me a lot. I have a couple of ideas/concepts; however, I am wide open for any new suggestions, ideas, constructive criticism, and/or anything else that will guide this project to fruition.
Okay, the basic concept is to have some sort of user interface for company users to perform searches based on particular item numbers and other attributes. Currently, I have a Discoverer Report that pulls a "Master Sheet" every night via DOS batch code. This is programmed to save the file with the date in the file name. I would like to have a centralized userform/spreadsheet that the users can input some data and search against this form without it being open.
The cause for this is that the file itself contains nearly 750,000 rows, each containing a specific/distinct item/part number and its attributes. It takes forever to open the file, plus it is somewhat inefficient to open this large file to find one attribute for a part number. I have researched the web and found that there are options using ADO and/or DAO methods. I am not fluent with these at all, hence I call out to the Experts.
If there is a better way to have this done via Excel, I am all ears. I greatly appreciate any help everyone. I can provide sample data/workbooks to whoever is brave enough to accept the challenge. Thanks again everyone and God bless!