Hi Everyone,

I have a workbook that contains an ODBC link to a database and using
MS-Query it fills a range in my workbook with some filtered data from
my source database.

My query is set up at the moment, more or less hard-coded, to get the
last 7 days of data. Because of the hard-coding, I have to go in to
the query manually and specify a new date parameter whenever the query
needs to be updated.

I'd like to be able to change the MS-Query data from Excel so that I
can change the filtering and sorting without the need to manually
modify the query every time.

Is this possible?

Regards


Greg