Collect data from excel using VB
Posted on 2006-06-19
I am VERY new to Visual Basic. I do have VB 6.0, but I wouldn't even say that I have a working knowlege of it. My question is this. I know there is a way to retrieve data from an excel spreadsheet using VB. I'm assuming this might be done in a way similar to SQL. What I would like to do is query my excel spreadsheet, using VB, and display the results in a VB program. I would like to set the program up to use multiple query criteria, selectable by a drop down list, and by a date range using a calendar. Based on what has been entered as the query criteria, I would like to have the resullts displayed in the VB program, with some minor calculations being made.
I AM NOT LOOKING FOR SOMEONE TO WRITE THE CODE FOR ME. I want to learn it myself. What I am looking for might be considered more of a lesson than anything. Possible resources, that would explain the necessary components needed to accomplish such a task, and how to implement them. The first Expert that provides usefu information will receive all 500 points.