Code to reference cell as parameter when pulling data

Hi,
I'm trying to design a spreadsheet where th user will enter a few parameters in a sheet and then press a button for a query to pull data.

I have the first thing done, which is the macro for the data. But don't know how to use the parameters for it.

My code is:

Please Login or Register  to view this content.

So where it says:

Please Login or Register  to view this content.

I want to be able to reference a cell in a sheet called "Parameters", for example cell D4,
the same with:

Please Login or Register  to view this content.

I don't want the dates to be fixed but to reference two cells in the "parameter" sheet.

I tried to do the parameters through the Data section, but because this query can't be shown graphically, microsoft query will not let me use the parameter option in excel.

Any ideas?
Any help will be appreciated.

Thanks.

Originally Posted by jaimealvarez

Please Login or Register  to view this content.

I want to be able to reference a cell in a sheet called "Parameters", for example cell D4,

Something like:

Please Login or Register  to view this content.

Originally Posted by jaimealvarez

Please Login or Register  to view this content.

I don't want the dates to be fixed but to reference two cells in the "parameter" sheet.

Like this:

Please Login or Register  to view this content.

and similarly for the other date-time.

You'll also need to ensure that all the strings are properly constructed with start and end double quotes, which I'll leave to you to sort out.