C
CarlosAntenna
I routinely query data from another application into Excel.
Is there any way to pass parameters into the query from the excel worksheet?
That is, I want to put a start date and end date in the excel worksheet and
then query for records dated within that range.
I can edit the query easily enough, but I want to turn this over to users
who would not understand how to use query and I don't want to spend a lot of
time teaching repeatedly and mopping up their messes.
Is there any way to pass parameters into the query from the excel worksheet?
That is, I want to put a start date and end date in the excel worksheet and
then query for records dated within that range.
I can edit the query easily enough, but I want to turn this over to users
who would not understand how to use query and I don't want to spend a lot of
time teaching repeatedly and mopping up their messes.