OK, so my question can either be answered one of two ways, and I don't mind whichever.

Background info
I'm trying to automate a process to pull data from ODBC backend tables into Excel for reporting purposes. The idea is to simplify, to reduce manual copy-pasting, and the end-user may not have access to MS Access on their PC (although this may not be the case).

The data that I am trying to look up is transactional (product codes, store numbers, transaction date/time) and I am only interested in data for certain periods of time (i.e. 4wks).

The question (please answer yes to one of them!)
a: Is it possible to use Excel's built in MS Query to create queries using a 'where' statement, and referencing data from a cell in the worksheet? I will be using a vlookup to search for the start and end dates, so that the query will (ideally) be automatic.

b: Is it possible to use MS Access to link to a worksheet in my Excel workbook, and take the values from the sheet as start and end dates? This way, I can use Excel just to do an external data query using the Access query, which is far more powerful than stupid MS Query.