I currently use Excel in conjunction with Microsoft Query to extract
data from a database and run certain reports. Most of these reports
must be based on a date range, or some other similar criteria. My
problem is that when I want to update the report for a new date range
or the like, I have to hit "edit query" to open up Microsoft Query,
then edit the criteria. I would like to know if there is a way to
update the parameters in the query without manually opening MS Query
and editing. I tried to create a macro that would do it for me without
any luck. Optimally, what I would like is either a macro that pops up
an input box for the user to enter new parameter(s), or I could have a
cell on the spreadsheet where I would enter a new parameter, then the
SQL code would take this cell's data and put it into the query for me.
This would make the reports much more user friendly to edit. Any ideas?


---
Message posted from http://www.ExcelForum.com/