Reporting from Excel
Posted by John Newbold on December 13, 2001 8:48 AM
It sounded so simple but it is a nightmare. I have a nifty simulation model written in Excel. I use a VB interface to feed input data into the model and then I run it. So far so good. Then I want to report the results in an attractive, meaningful way: tables, graphs, diagrams, without the user being able to hack around in my program. Not an unreasonable objective. Nightmare. I was advised to use Crystal Reports, linking to Excel via ODBC. Takes forever and a day to refresh - simply not acceptable. In desperation resorted to the free Microsoft Excel Viewer. Made myself a pretty diagram as a separate 'xls' file, with an automatically updated link to my main 'xls' program. Then wrote VB code to launch the diagram file via Excel Viewer. Problem: the data don't refresh.
Frustration setting in big time. All I want to do is construct and manage (print, save) atttractive reports based on my Excel data. How can I do this? Why is it so difficult?
Any help or advice would be invaluable.