I need to pull data from SQL Server into Excel 2007. The data requires that a
date parameter be passed in -- and I can access the data either with a table
function [select * from myfunc(?)] or a stored procedure [exec myproc ?].

However, after spending an hour or so messing around with the data import
features, it seems that the SQL Server choice does not allow parameters, and
the Microsoft Query version does not allow parameters for queries that it
can't display graphically. Even if I mess around the MS Query version
afterwards, I can't seem to get this to work.

Is this an oversight on my part? How should I be approaching this?

I would like the parameter to be populated by a cell on a worksheet, but
prompting the user to enter it is also acceptable. I'd like to avoid VBA or
Macros for this.