I need a program written in VB6 that populates some cells in an Excel Spreadsheet with data from Access queries. The queries are already written and the SQL code attached to the project.
This project should be very simple and fast for someone who already has experience with VB6 and MS office objects. The hardest part will be understanding the spreadsheet . . but I outlined it very clearly and you should be able to see the data match up between the database and the sample in the spreadsheet. Use the dates Sept 2 and Sept 3 for comparing the data.
There are 2 other pieces to this project but this piece is needed asap so I can't wait and have it all done at once.
The user interface will be very simple. The user needs to input a date range for beginning and ending date and then click a button to create a new spreadsheet.
The complete specs are included in an RTF file. I also attached a sample database and spreadsheet.
Don't hesitate to ask questions.