BH
1. Create a vb.net program which will pull data from quickbooks using "qbfc"(the Quickbooks sdk) I will provide the connection string and query as well as the current way I parse the data with vba. Txt file attached . The sdk is attached as well
2. Insert the data into an sqllite database.
3. Create an excel pivot table by salesman and there total sales using the data stored in the sqllite database.
4. User form with a start date end date.
5. User form where you can query the sqllite database.
6. The ability to update the app remotely
7. Create an installation file with sqllite and qbsdk bootstrapped to the program