I understand how to save an excel database list as an HTML file.
What I want to do is "push a button" have the computer do some calculations and then based on calculation results, pick and choose data from various data base lists and display the chosen data in an HTML format.
How could this be done?
How can I choose data from Excel database lists and display the chosen data in HTML?
This is a terribly open-ended question. If you are keeping your databases in Excel, you're going to run into some problems with a system like this. You would be far better off using something like Access.
It sounds like you need to build a query statement that contains criteria based on the outcome of some formulas in Excel. Is this true?
It can certainly be done (anything can be done in software), but I think it will be very expensive to have it done, unless you have a good vba programmer on staff.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment