We have an Excel spreadsheet that is designed to pull data out of a QuickBooks database and post the data cleanly in a spreadsheet in a format easy for customers to understand. We also have designed a VB.Net application that allows a variety of reports types to be kicked off and run automatically pointing the report to the current datasource or DSN and running the report so results are available for users.
We wanted to know mlmcc (Senior Expert on EE) and I if it was possible to create a spreadsheet that like a Crystal Report, Access Report or SQL Reporting Service could be scheduled to run in our application which we know how to do but to somehow engage the spreadsheet to run against the preset database stored in the spreadsheet automatically.
What would we need to build in the spreadsheet to make that happen. Currently we have a simple execute button inside the custom spreadsheet that the customer clicks on after entering the DSN and a Date Range. Any support is greatly appreciated.