troubleshooting Question

Can an application written in VB.NET be setup to run an excel file that runs against a database

Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America asked on
.NET ProgrammingMicrosoft ExcelVB Script
6 Comments2 Solutions436 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Ken Fayal
CTO

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros